Multiple choice technology databases

Which of the following can duplicate the structure and related objects of a database table?

  1. Copy table

  2. Alter table

  3. Export table

  4. Generate DDL

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DDL (Data Definition Language) contains the SQL commands that define database structures like CREATE TABLE. Generating DDL allows you to duplicate table structure along with constraints and indexes. Copy/Alter/Export table operate on data, not structure.