What are DDL commands explain?

What are the DDL commands in database?

SQL DDL CommandsCREATE – Create an object. ... DROP – This SQL DDL command helps to delete objects. ... ALTER – Used to alter the existing database or its object structures.TRUNCATE – This SQL DDL command removes records from tables.RENAME – Renaming the database objects.

What are the 3 DDL commands?

List of DDL commands:CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).DROP: This command is used to delete objects from the database.ALTER: This is used to alter the structure of the database.

What is DDL command class 10th?

DDL is short form of Data Definition Language statements are used to build and modify the structure of database, tables and other objects in the database. When you execute a DDL statement, it takes effect immediately. Some of the commands comprising DDL are CREATE TABLE, DROP TABLE and CREATE INDEX.

How many DDL commands are there?

DDL DML DCL SQL sentences There are 3 main types of commands.