/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

11 votes251 views3 answers
How to get last row of table in sql
SQL
0 vote327 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
2 votes228 views1 answer
How to search table name in stored procedure in sql server
SQL
17 votes302 views4 answers
Show all tables in oracle
SQL
7 votes230 views1 answer
Safe mode mysql
SQL
0 vote243 views1 answer
Is not numeric sql
SQL
0 vote305 views1 answer
Python get backup of sql
SQL
3 votes219 views1 answer
System.debug apex
SQL
-1 vote226 views1 answer
Export mysql table to file
SQL
1 vote223 views1 answer
Postgres format date in select
SQL

Share