If you only need metadata copied from schema1.city to schema2.city, which statement would you run?

If you only need metadata copied from schema1.city to schema2.city, which statement would you run?

• A. INSERT INTO schema2.city SELECT * FROM schema1.city;
• B. SELECT * INTO schema2.city FROM schema1.city;
• C. CREATE TABLE schema2.city AS CLONE OF schema1.city;
• D. CREATE TABLE schema2.city AS SELECT * FROM schema1.city;

Answer: (C)

Copying metadata without moving data hinges on creating a new table that has the same structure as the source but without duplicating the actual rows. In practice, cloning a table achieves this: you get a new object with identical columns, types, and constraints, and the storage is not physically copied at creation time. The statement that creates a table as a clone of another is the right choice because it reproduces the schema efficiently while keeping data separate and shared, allowing you to evolve the two tables independently later. Other options would bring over data. Inserting from the source copies all rows into the destination. Selecting into a new table or creating a table as select would populate the new table with data as well, not just the metadata.

Copying metadata without moving data hinges on creating a new table that has the same structure as the source but without duplicating the actual rows. In practice, cloning a table achieves this: you get a new object with identical columns, types, and constraints, and the storage is not physically copied at creation time. The statement that creates a table as a clone of another is the right choice because it reproduces the schema efficiently while keeping data separate and shared, allowing you to evolve the two tables independently later.

Other options would bring over data. Inserting from the source copies all rows into the destination. Selecting into a new table or creating a table as select would populate the new table with data as well, not just the metadata.