hello!
am getting an error while creating this table,
(Schema Creation Failed: A table must have at least 1 column:)
create table EMP_TABLE
{
Name Varchar(20),
ID int not null,
Age int,
Salary float (20,2),
primary key(ID)
};
{
Name Varchar(20),
ID int not null,
Age int,
Salary float (20,2),
primary key(ID)
};
Khan Abrar AhmedPosted Jun 30, 2014, 5:36 AM
create table EMP_TABLE
(
Name Varchar(20),
ID int not null,
Age int,
CONSTRAINT [PK__id] PRIMARY KEY CLUSTERED
(
ID ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]