TRUNCATE: remove all records from a table, including all spaces allocated for the records are removed.ALTER: alters the structure of the existing database.CREATE: to create a database and its objects like (table, index, views, store procedure, function, and triggers).which helps in efficient retrieval, insertion and deletion of data from it.ĭDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database. For Example, university database organizes the data about students, faculty, and admin staff etc. Database: Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |