/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 vote182 views2 answers
Mysql add column tinyint default 0
SQL
2 votes198 views1 answer
Orcale index size
SQL
0 vote177 views1 answer
Mysqldump: error:
SQL
0 vote145 views1 answer
Sql server select furst day of current year
SQL
3 votes101 views1 answer
How to get list of synonyms in oracle
SQL
1 vote161 views1 answer
Oracle create_program
SQL
0 vote147 views1 answer
How to use group_concat in sql server
SQL
0 vote162 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote145 views1 answer
Test connection to sql server
SQL
1 vote186 views3 answers
Divide by zero error in sql
SQL

Share