/SQL/Create table from existing table in sql

Create table from existing table in sql

Create table from existing table in sql

//this will create new Empty table

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

1

Create new table from existing table with data in sql server

CREATE TABLE florist 
AS SELECT
  *
FROM product
WHERE category = ’flower’;

0

Source: learnsql.com

Create new table from existing table with data in sql server

INSERT INTO new_table
SELECT * FROM old_table

0

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
Gcloud sql list databases
SQL
1 vote122 views1 answer
Mysql copy table1 to table2
SQL
0 vote112 views1 answer
Java sql insert return id
SQL
0 vote141 views1 answer
Oracle date summer time
SQL
8 votes114 views2 answers
Mysql get first x characters
SQL
0 vote139 views1 answer
How to to get time in sql
SQL
2 votes128 views2 answers
Postgres timestamp to datetime
SQL
1 vote125 views3 answers
How to pass password to mysql command line
SQL
4 votes78 views1 answer
Oracle sleep
SQL
0 vote122 views1 answer
Grant access on table in oracle
SQL

Share