I am having problems with the syntax on adding a primary key to an existing table. I can add it through Enterprise manager, but no sql.
Here is what I thought it should be based on
DB = purchasing (selected in sql analyzer)
table = classcodes
column (not null) = class
alter table classcodes
alter column class
add constraint pk_class primary key
thanks,
Joseph