how to drop the identity on a colum from sql

[varadish]

HI,
how can i drop the identity on a column from the table.
I have no access to the sql enterprise manager, i have to do it thru query analyser only.
regards,
varadish

Use the alter table statement

------------
varadish at 2/14/01 9:33:38 AM


HI,
how can i drop the identity on a column from the table.
I have no access to the sql enterprise manager, i have to do it thru query analyser only.
regards,
varadish

[varadish]

hi,
can u be more specific.
i am trying with alter table but, couldn't find the correct syntax.
thanx,
varadish


------------
at 2/14/01 9:35:53 AM


Use the alter table statement

------------
varadish at 2/14/01 9:33:38 AM


HI,
how can i drop the identity on a column from the table.
I have no access to the sql enterprise manager, i have to do it thru query analyser only.
regards,
varadish

[Peter Main]

ALTER TABLE table_name
DROP COLUMN column_name


------------
varadish at 2/14/01 9:40:21 AM

hi,
can u be more specific.
i am trying with alter table but, couldn't find the correct syntax.
thanx,
varadish


------------
at 2/14/01 9:35:53 AM


Use the alter table statement

------------
varadish at 2/14/01 9:33:38 AM


HI,
how can i drop the identity on a column from the table.
I have no access to the sql enterprise manager, i have to do it thru query analyser only.
regards,
varadish