/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

0 vote256 views1 answer
Call procedure in wordpress
SQL
3 votes250 views3 answers
Update join
SQL
10 votes258 views3 answers
Join multiple tables sql
SQL
11 votes255 views3 answers
Change column name sql server management studio
SQL
4 votes249 views1 answer
Delete record mysql query
SQL
0 vote242 views1 answer
Min salary in sql
SQL
8 votes243 views2 answers
Phpmyadmin password
SQL
0 vote256 views2 answers
Sql use not in
SQL
9 votes272 views4 answers
Postgresql export database
SQL
0 vote257 views1 answer
How to combine rows in sql server procedure
SQL

Share