Tuesday, April 12, 2016

Create syntax

SQL create table clause use for create table in database. In this table col_name point the name of the column. The datatype point out the data on this column. The size specifies  length of the column.


CREATE  TABLE  T
(
   col_name1 datatype(size),
   col_name2 datatype(size)
);

Now we create a table named "T" which have three column  StuId,Firstname,LastName

Example Query :

CREATE  TABLE  T
(
  StuId int(11),
  FirstName varchar(110),
  LastName varchar(110),
 );

No comments:

Post a Comment