/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 vote207 views1 answer
Pl sql round
SQL
2 votes158 views2 answers
How to check database username and password in postgresql
SQL
0 vote194 views1 answer
Repeatable read trong sql server
SQL
0 vote162 views1 answer
Mysql grant all on all databases
SQL
0 vote176 views1 answer
Get date ISO in psql
SQL
1 vote167 views1 answer
Oracle grant on all tables in schema
SQL
0 vote210 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
5 votes165 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote189 views1 answer
Postgres full text search example
SQL
2 votes194 views1 answer
Python sql
SQL

Share