Saturday 18 October 2014

DDL Commands



DDL (Data Definition Language):-
            It is used to create, modify, truncate and drop the table (Database object) in database.

Create             :           Creates tables in the database
Alter                :           Alters table tables in the database
Drop                :           Deletes table in the database.
Truncate         :            Deletes all records from a table and resets table identity to
initial value.

No comments:

Post a Comment