Translate to Tamil

Offers

Amazon Offers

Offers

AliExpress Offers

Broadcast

Online Income

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