/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

3 votes246 views1 answer
Sql cast to integer
SQL
0 vote275 views1 answer
Selecting from a view SQL
SQL
0 vote266 views1 answer
Enable Rabbitmq management plugin
SQL
4 votes260 views1 answer
Oracle error compilation line
SQL
0 vote266 views1 answer
Add computed column to table sql server
SQL
0 vote265 views2 answers
Sql if empty then
SQL
0 vote283 views1 answer
Mysql cli output to a file
SQL
-2 votes261 views1 answer
Modify column name in tsql
SQL
3 votes281 views2 answers
How to open postgresql in windows
SQL
0 vote280 views2 answers
Mysql where in maintain order group_concat
SQL

Share