MySQL Database Tutorial #11 | Implementation of DDL Commands | Create | Alter | Drop | Truncate |

#DDLCommands #Create #Alter #Drop #Truncate

To execute and verify the Data Definition Language commands

DDL (DATA DEFINITION LANGUAGE) COMMANDS

1. CREATE
COMMAND DESCRIPTION: CREATE command is used to create objects in the database.

2. DROP
COMMAND DESCRIPTION: DROP command is used to delete the object from the database.

3. TRUNCATE
COMMAND DESCRIPTION: TRUNCATE command is used to remove all the records from the table

4. ALTER
COMMAND DESCRIPTION: ALTER command is used to alter the structure of database

5. RENAME
COMMAND DESCRIPTION: RENAME command is used to rename the objects.