I have a problem setting primary key and null value to my SQL database that
have been migrated from Access. All the primary key are removed during the
migration.

I was trying to write a procedure to programmatically set primary key and
remove AllowNull Value for each field (that have ID at the end of field
name)in the table using ALTER TABLE TABLE_NAME ALTER COLUMN ... but did not
get any success (maybe due to I am not writing the correct statement. Could
anyone suggest something on this

SAM

AFAIK there is no ALTER COLUMN part of ALTER TABLE, just {ADD | DROP} COLUMN
That means that you must move the data, drop the column, re-create the
column.

--
Regards,
Bas Cost Budde
soon resigning not from nospam but wegener

Management Information System wrote