What are various DDL commands in SQL? Give brief description of their purposes.


Following are various DDL or Data Definition Language commands in SQL −

  • CREATE − it creates a new table, a view of a table, or other object in database.

  • ALTER − it modifies an existing database object, such as a table.

  • DROP − it deletes an entire table, a view of a table or other object in the database.


© 2017