Programming Blog
Wednesday, January 6, 2010
Creating table in a database with primary key
Syntax:
create table
table_name
(
column_name
datatype(size) PRIMARY KEY,
column_name1
datatype(size),..
n
);
Example:
create table sem(sem_id int PRIMARY KEY,sem_name char(30));
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment