Getting rid of the IDENTITY property on a column withou getting rid of the column 
Author Message
 Getting rid of the IDENTITY property on a column withou getting rid of the column
Hi all,

Using T-SQL, how do I get rid of the identity property on a column without
dropping the column or moving the data. I just want a plain old int.

Thanks

Kieran



Tue, 01 Oct 2002 03:00:00 GMT
 Getting rid of the IDENTITY property on a column withou getting rid of the column

Is this SQL 7?  If so, try ALTER TABLE.


Quote:
> Hi all,

> Using T-SQL, how do I get rid of the identity property on a column without
> dropping the column or moving the data. I just want a plain old int.

> Thanks

> Kieran



Tue, 01 Oct 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Getting rid of IDENTITY

2. GETTING RID OF DUPLICATE COLUMNS..

3. Getting rid of a column in a table

4. Agility Grid Control, Getting rid and bringing back columns

5. getting rid of characters in database

6. Getting unwanted data that I can't get rid of

7. Getting rid of the time part

8. Getting rid of excess lseeks()

9. Getting Rid of toolbar in the DataReports

10. getting rid of duplicates

11. Getting rid of Primary Log file - SQL 2K

12. GETTING RID OF 3D EFFECT ON BUTTONS


 
Powered by phpBB® Forum Software