/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

14 votes169 views1 answer
Excel
SQL
2 votes175 views1 answer
Oracle sql drop column if exists
SQL
0 vote199 views1 answer
Sql quary stuf
SQL
0 vote125 views1 answer
Check sql query executed wp
SQL
-1 vote182 views5 answers
Convert sql to linq query online
SQL
5 votes160 views1 answer
Sql first day of current year
SQL
0 vote187 views1 answer
Snowflake drop column
SQL
0 vote302 views1 answer
Provera dupliranih konatakata
SQL
0 vote194 views1 answer
Count in sql and diff
SQL
1 vote196 views1 answer
Minus vs intersect in sql
SQL

Share