Priority Technology Holdings Interview Questions, Process, and Tips

DDL commands are used to define and manage the structure of a database.

• DDL stands for Data Definition Language.

• DDL commands are used to create, modify, and delete database objects such as tables, indexes, and views.

• Examples of DDL commands include CREATE, ALTER, and DROP.

• DDL commands do not manipulate the data within the database, only the structure.

Truncate is a DDL statement that removes all rows from a table, while delete is a DML statement that removes specific rows.

• Truncate is faster than delete as it doesn't generate any rollback information.

• Truncate cannot be rolled back, while delete can be.

• Truncate resets the identity of the table, delete does not.

• Truncate does not fire triggers, delete does.

• Truncate is non-logged operation, delete is logged.