Question

create the table with suitable data types. please answer.​

Answer 1

Answer:

1. CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ...

2. Example. CREATE TABLE Persons ( PersonID int, ...

3. CREATE TABLE new_table_name AS. SELECT column1, column2,... FROM existing_table_name. ...

4.Example. CREATE TABLE TestTable AS. SELECT customername, contactname.