/SQL/Create empty table from existing table

Create empty table from existing table

Create empty table from existing table

//this will create new Empty table

CREATE TABLE TableName AS (SELECT * FROM ExistingTable WHERE 1=2);

1

Write a query to create an empty table from an existing table?

CREATE TABLE new_table
  AS (SELECT *
      FROM old_table WHERE 1=2);

1

Source: techonthenet.com

Similar codes

2 votes187 views3 answers
Postgres remove foreign key constraint
SQL
0 vote224 views1 answer
Plpgsql if statement
SQL
1 vote233 views3 answers
Alter schema sql server
SQL
1 vote298 views1 answer
Sql server delete top 1000
SQL
1 vote295 views1 answer
Sql server read uncommitted
SQL
0 vote154 views1 answer
Psql not found windows
SQL
0 vote193 views1 answer
Postgresql default value boolean
SQL
5 votes279 views4 answers
Restart the psql server windows
SQL
0 vote233 views1 answer
Sql server beginning of month
SQL
0 vote188 views1 answer
Vowels in sql
SQL

Share