Posted On: Feb 22, 2018
DDL commands are used to modify and edit the structure of a database system. Some of the important commands are-
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]
ALTER table command- ALTER is used to make changes and edit the existing table of database. Syntax: ALTER objecttype objectname parameters.
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.
Never Miss an Articles from us.
There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..