Hi all,
Is there a way to remove the identity from a column
by using alter table
thanx
Remove identity
Hot Topic
- Instead Of Update Trigger w/ Self-Referencing Table
- Criteria validation Reporting Server
- raw file source avoid bad data?
- Where is the Northwind SQL scripts for SQL server 2005
- How to add SQL statements to the package created by Export Data wizard?
- CANT CONNECT TO SQL SERVER
- Credentials in Data Sources are getting locked out of SQL
- sql autoincrement
- Encryption Keys (Reporting Services Configuration)
- Setting default values for report items
SQL Server
- Custom source adapter UI
- I don't understand why is nothing is always evaluated to false
- "the parameter is incorrect" when trying to add a table
- What directory would be best to store the .SDF file in?
- Accessing AS400 Data
- Dynamically Generating SMDL (Report Model Definitions) With C#
- Cube Actions, how can I create a Command line action
- Can I change report style at run time?Urgency!
- Package Validation Error + Code 0xC004801C
- Neither System.DbNull or NULL??
Remove identity
Dave Collins
Hi,
"disabling" the property does the things behind the scenes I mentioned in my earlier post. In SQL 2k (I didn't check that in SQL2k5 right now) it did a creation of a new table, copy the data to the new table, and renamed the table vice versa to the new / old name.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Spartan
Hi,
identity is no property, you have to create another column, copya the values to the new column and drop the old one.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
nihk
In the SQL Server Management Studio Express, when I right click in table, and I choice the modify option, bellow appear the column properties where I set the Identity Specification to No or Yes.
This option disables/enable the identity
But is there a way to disable the identity via command line
thanx
DarkDragon03