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

on Identity (1, 1) optional table employee Add PK_Authorities with primary key (employee) (Statistics I, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -