SQL Create Table

The CREATE TABLE statement is used to create a table in a database.

Create Table Syntax 

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

Create Table Example

 Create Table CustMast (

custcode numeric (12, 0),

custname varchar (50), 

city varchar (50), 

qty numeric (12, 0),

rate numeric (12, 2) )

 Learn to Sql Data Types  Click Me