Question

what is DDL and mention any two DDL statement??

Answer 1

hiii dear________❤️❤️❤️
good morning____________✌️✌️✌️


DDL or Data Definition Language are statements used to Create, Alter, Drop Database Objects, like Tables, Views, SPs, etc.


Some examples:

– CREATE : used to define new objects

– ALTER : used to modify the definition of existing objects

– DROP : used to remove existing entities.

– TRUNCATE TABLE : used to remove all rows from a table without logging the individual row deletions.

– UPDATE STATISTICS : used to update query optimization statistics on a table or indexed view.