State some commands of DDL in DBMS ?

DDL commands are used to modify and edit the structure of a database system. Some of the important commands are-

1. CREATE table command- It defines each column of the table in a unique and distinct manner like name, data type, size, etc.

   Syntax: CREATE TABLE [column name] ([column definitions]) [table parameters]

2. ALTER table command- ALTER is used to make changes and edit the existing table of database. Syntax: ALTER objecttype objectname parameters.

3. DROP table command – DROP is used for destroying a table and all the recorded data in it. It destroys an existing database.  Syntax: DROP objecttype objectname parameters.