Question: dbms how to create table?
Answer: CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ... 
Example. CREATE TABLE Persons ( PersonID int, LastName varchar(255), ... 
CREATE TABLE new_table_name AS. SELECT column1, column2,... FROM existing_table_name. WHERE ....;
Example. CREATE TABLE TestTable AS. SELECT customername, contactname.