/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

0 vote301 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote280 views1 answer
Display first three characters sql
SQL
1 vote320 views1 answer
Oracle see column type
SQL
0 vote250 views1 answer
Deleted table in sql trigger
SQL
1 vote276 views1 answer
Increase date by one day in sql oracle
SQL
0 vote284 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote310 views2 answers
Sql stored procedure for access frontend
SQL
0 vote275 views1 answer
Opensuse start MySQL
SQL
0 vote292 views1 answer
Greater than or equal to symbol in postgres
SQL
2 votes297 views1 answer
Oracle list duplicates
SQL

Share