How to create a table ?EMPIDE Char(4)EMPNAME Varchar(15)DESIGN Varchar

1.	How to create a table ?EMPIDE Char(4)EMPNAME Varchar(15)DESIGN Varchar(20)SALARY Decimal
Answer» SQL\xa0CREATE TABLE\xa0StatementCREATE TABLE\xa0table_name ( column1 datatype, column2 datatype, column3 datatype, ...Example.\xa0CREATE TABLE\xa0Persons ( PersonID int, LastName varchar(255), ...CREATE TABLE\xa0new_table_name AS. SELECT column1, column2,... FROM existing_table_name. WHERE ....;Example.\xa0CREATE TABLE\xa0TestTable AS. SELECT customername, contactname.

Discussion