April 3, 2003 at 7:40 am
Hi,
how I can change column property from identity to not identity?
Thanks,Jelena
April 3, 2003 at 7:53 am
With Alter Table.
For example:
if you create the table with
Create Table TableName
(ColumnName INT IDENTITY (1,1))
ALTER TABLE TableName
ADD ColumnName INT
April 3, 2003 at 7:57 am
I am not sure it is so simply....
Jelena
April 3, 2003 at 9:39 am
Sorry, I meant
ALTER TABLE TableName
Alter Column ColumnName INT
April 4, 2003 at 1:47 am
Or simply use Design Table option in EM and remove tick from identity.
Far away is close at hand in the images of elsewhere.
Anon.
April 4, 2003 at 2:38 am
Thanks,
I know it can be done in EM, but I thought to make that in code.I read it can not be done in code...
Jelena
April 4, 2003 at 6:49 am
When you make the change in EM, click the script button - 3rd button from left I think, see what it gives you. Remember too that there is no magic, you can always run Profiler to see what's going on.
Andy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply