- CREATE TABLE table_name ( column1 datatype, column2 datatype, …
- ExampleGet your own SQL Server. CREATE TABLE Persons ( PersonID int, …
- CREATE TABLE new_table_name AS. SELECT column1, column2,… FROM existing_table_name. …
- Example. CREATE TABLE TestTable AS. SELECT customername, contactname.
BrindhaPrathaban Answered question July 5, 2023
SQL TABLE CREATE STATEMENT
CREATE TABLE table_name (datatype column1, datatype column2,…
ExamplePurchase your own SQL Server. CREATE TABLE Persons (int PersonID,…
AS new_table_name CREATE TABLE. EXAMPLE: SELECT column1, column2,… FROM existing_table_name. CREATE TABLE AS TestTable. SELECT customername, contactname from the list.
Vishalini.R Answered question July 5, 2023
