Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

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


No comments:
Write comments

Infolinks

Services

© 2014