Database Object Management Using DDL

University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2024
Views:

102

Pages:

1
Author:

Venesia A.

Database Object Management Using DDL DDL For Database In the context of SQL, data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include vie schemas, tables, indexes, etc. DDL Command 1. CREATE To create a database and its objects like (table, index, views, store procedure, function, and triggers) 2. ALTER To alters the structure of the existing database 3. DROP Delete objects from the database 4. TRUNCATE Remove all records from a table, including all spaces allocated for the records are removed 5. COMMENT Add comments to the data dictionary 6. RENAME Rename an object