Home / Report Question

Q. Which statement creates a copy of an existing table structure without copying data?
  • A. CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=0
  • B. CREATE TABLE new_table LIKE old_table
  • C. INSERT INTO new_table SELECT * FROM old_table LIMIT 0
  • D. ALTER TABLE old_table RENAME TO new_table