/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

1 vote270 views1 answer
Rows to comma separated values in mssql
SQL
1 vote284 views1 answer
Mysql connect bash
SQL
0 vote283 views1 answer
Search from comma separated values in sql server
SQL
0 vote313 views1 answer
How to use sqlcommand
SQL
17 votes292 views4 answers
Show tables sql server
SQL
0 vote252 views1 answer
Deny select insert update delete sql
SQL
27 votes323 views3 answers
Mysql delete row
SQL
0 vote259 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote248 views1 answer
Recursive query herarchical data sql server
SQL
1 vote261 views2 answers
Mysql select tables with name like
SQL

Share