How can I duplicate a table in SQL without data?

Question

Copy all columns from selected table. Select Top 0 * into NewTable from OldTable. Copy some columns from selected tablehow to create a duplicate table with no data in itCreate table (structure) from existing table - sql serverCopy table without copying data - mysqlCopy table structure into new table - sqlДругие результаты с сайта stackoverflow.com

How can I duplicate a table without data in SQL?

The first method is called Simple Cloning and as its name implies it create a table from another table without taking into account any column attributes and indexes.1CREATE TABLE new_table SELECT * FROM original_table;2CREATE TABLE adminUsers SELECT * FROM users;3CREATE TABLE new_table LIKE original_table;How To Clone Tables in SQL - Towards Data Science

How do I copy a table without data?

CREATE TABLE new_table AS (SELECT * FROM old_table WHERE 1=2); For example: CREATE TABLE suppliers AS (SELECT * FROM companies WHERE 1=2); This would create a new table called suppliers that included all columns from the companies table, but no data from the companies table.

How can I duplicate a table in SQL?

Cloning or Copying a Table1CREATE TABLE new_table LIKE original_table; ... 2INSERT INTO new_table SELECT * FROM original_table; ... 3mysql> CREATE TABLE employees_clone LIKE employees; ... 4mysql> INSERT INTO employees_clone SELECT * FROM employees; ... 5CREATE TABLE new_table SELECT * FROM original_table;SQL Cloning or Copying a Table - Tutorial Republic

Expert · Answer