alter field type

[capik79]

Hi Guys,
I'm using SQL server 2000.

How do I alter column/field from type int (with Identity = Yes Not For Replication) to just normail int field. No more identity. I want it to be done using SQL script( sql query analyzer).

Please help me on this, thx

Regards,
Shaffiq

[Hack]

This should hit the spot.

[artcn]

You can use the ALTER TABLE command to achieve what you are looking for.