What Are The Different Ddl Commands In Sql?

1.	What Are The Different Ddl Commands In Sql?
Answer» DDL COMMANDS are USED to define or alter the STRUCTURE of the database. CREATE: To create databases and database objects ALTER: To alter existing database objects DROP: To drop databases and databases objects TRUNCATE: To remove all records from a table but not its database structure RENAME: To rename database objects DDL commands are used to define or alter the structure of the database. CREATE: To create databases and database objects ALTER: To alter existing database objects DROP: To drop databases and databases objects TRUNCATE: To remove all records from a table but not its database structure RENAME: To rename database objects

Answer»

DDL COMMANDS are USED to define or alter the STRUCTURE of the database.

CREATE: To create databases and database objects

ALTER: To alter existing database objects

DROP: To drop databases and databases objects

TRUNCATE: To remove all records from a table but not its database structure

RENAME: To rename database objects

DDL commands are used to define or alter the structure of the database.

CREATE: To create databases and database objects

ALTER: To alter existing database objects

DROP: To drop databases and databases objects

TRUNCATE: To remove all records from a table but not its database structure

RENAME: To rename database objects

Discussion