Do you know the different DDL commands in SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

The commands which are used in SQL to define the structure of database are called as DDL commands. Its types are:

  • Create - this command is used to create the databases and its objects.
  • Alter - this command is used to alter the existing database objects.
  • Drop - this command is used to delete the existing data or database objects.
  • Truncate - this command is used to remove the records from the table but not actually from the structure.
  • Rename - this command is used to rename the database objects.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...