Question

216 viewsJuly 5, 2023Others#SQL

1

Riya 2.92K May 23, 2023 0 Comments

How to create a new table in SQL?

score 0 · Answer 1 · 2023-07-05T15:05:26+00:00

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.

Questions