search

kelumKP / Sample-Codes

This is sample code 100% made by me for future references
0 stars 0 forks source link

field to existing dB set identity #5

Open kelumKP opened 8 years ago

kelumKP commented 8 years ago

add a field to existing dB is identity=yes,identity increment=1 ,identity seed=1 in sql server

     ALTER TABLE AspNetUsers
     ADD FileId int NOT NULL IDENTITY (1,1)