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.