How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)?

Asked Nov 15 '15 at 01:18

Active Nov 15 '15 at 07:50

Viewed 104 times

Create Table ProspectiveTenant
(
PTID int,
Name varchar (25),
Email varchar (25),
ApplicationFillDateTime Date,
MetSamanthaDateTime Date
Add (PTID) Identity (1,1)--this is not working

edited Nov 15 '15 at 07:50

Giorgi Nakeuri

35,155
8
47
75

asked Nov 15 '15 at 01:18

Matt

1

Next time you post a question, _post the error_. This might help: http://stackoverflow.com/questions/10725705/how-to-create-table-with-identity-column – Nick.Mc Nov 15 '15 at 07:49
You **cannot** add `IDENTITY` to an existing column - you have to define a column as `IDENTITY` at the time the table is created – marc_s Nov 15 '15 at 08:52

How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)?

0 Answers0