Question:

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

Answer:

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.


Keywords:

© 2017 QuizBucket.org