/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 vote301 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote343 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote333 views2 answers
How to check username in mysql command line
SQL
0 vote339 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote371 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
7 votes371 views3 answers
Sql set
SQL
0 vote292 views1 answer
Sql count how many times a value appears
SQL
0 vote338 views1 answer
Sql server bool select
SQL
0 vote387 views1 answer
How to use sqlcommand
SQL
15 votes355 views5 answers
Show tables in oracle
SQL

Share