Sunday, 15 August 2010

sql - Invalid Identifier in ALTER TABLE ADD COLUMN -



sql - Invalid Identifier in ALTER TABLE ADD COLUMN -

i'm getting error "invalid identifier" whilst running alter table statement:

alter table truck add together column weight integer not null;

the syntax this, don't understand error:

alter table table_name add together column column_name data_type[not null][unique]

the attribute weight doesn't need unique.

how include "not greater 1000" integer info type alter statement?

sql server:

alter table truck add together weight int not null

sql alter-table

No comments:

Post a Comment