Wednesday, January 6, 2010

Creating table in a database

Syntax:
create table table_name(column_name datatype(size),column_name1 datatype(size),..n);

Size might be optional depends upon the datatype and column you are using in that table.

Example:
create table sem(sem_id int,sem_name char(30),dept_date date);

No comments:

Post a Comment