Scribd
Upload
13 views3 pages

DDL Command

DDL command in DBMS.

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views3 pages

DDL Command

DDL command in DBMS.

Uploaded by

indrabhan919
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Experiment No- 04

AIM: TO PERFORM THE DDL (Data Definition Language) commands.

Create Command: It is used to create a database or table.

Syntax: CREATE TABLE tableName(Column1 Datatype, Column2 Datatype,……);

Alter Command: It is used to make changes in the structure of a database or table.

Syntax: ALTER TABLE tableName ADD ColumnName Datatype;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025


Truncate Command: It is used to delete the Entities inside a table while holding the structure of
the table “Removing all rows from the table”.

Syntax: TRUNCATE TABLE tableName;

Rename Command: Rename command is used to rename a table.

Syntax: RENAME TABLE tableName to newTableName;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025


Drop Command: It is used to completely delete a table from the database.

“Removing existing table along with it’s structure.”

Syntax: DROP TABLE tableName;

NAME- INDRA BHAN VERMA ROLL NO- 2204220130025

You might also like