sql - Alter Table Add Column Syntax -
I'm trying to add an identification column to the program in a table to make sure the employee is wrong with my syntax I am doing
Optional columns Employee Column Add Employee Staff Tap Identification (1, 1) Optional Table Employee Include PK_Employees with Primary Key Cluster (Employee) (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = Current, ALLOW_PAGE_LOCKS = on) [primary] What am I doing wrong? I tried to export the script, but SQL MGMT Studio works to rename a complete temporary table.
UPDATE : I think it's the first statement on the "incorrect syntax keyword 'COLUMN."
Remove ADD column
Comments
Post a Comment