Answers for "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);

Posted by: Guest on January-31-2022

create new table from existing table with data in sql server

INSERT INTO new_table
SELECT * FROM old_table

Posted by: Guest on July-13-2021

create new table from existing table with data in sql server

CREATE TABLE florist 
AS SELECT
  *
FROM product
WHERE category = ’flower’;

Posted by: Guest on July-13-2021

Code answers related to "create table from existing table in sql"