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