Monday, 2 May 2011

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) 
)

 Share This Post


Friendly Learn Translate to Tamil

Smilely

Services

© 2014