Which SQL DDL statement creates an empty copy of an existing table?

• A. CREATE TABLE ... AS SELECT
• B. CREATE TABLE ... LIKE
• C. CREATE TABLE ... CLONE
• D. CREATE TABLE ... WITH TEMPLATE

Answer: (B)

When you want a new table that has the same structure as an existing one but no data, you need to duplicate the schema only. This is exactly what copying the table’s schema with a structure-based statement does: it creates a new table that has the same columns and data types (and related attributes) as the original, but it starts empty.

That’s why this option is the best fit: it yields an empty table that matches the existing table’s shape, ready for data to be inserted. In contrast, using a statement that selects data would populate the new table, so it wouldn’t be empty. A clone reproduces the original table’s data at the moment of cloning, not just its schema, so it isn’t an empty copy by default. The template-based approach isn’t a standard way to create an empty copy of a table’s structure.