Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Identity Column

  
   Database Help (Home) -> Programming RSS
Next:  Collation changing script  
Author Message
Vedran

External


Since: Aug 03, 2006
Posts: 7



(Msg. 1) Posted: Thu Jan 18, 2007 3:14 pm
Post subject: Identity Column
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Is it possible to set the indentitiy flag for a column by simply using alter
table/alter column in SQL 2000
and SQL 2005.

 >> Stay informed about: Identity Column 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 2) Posted: Thu Jan 18, 2007 3:14 pm
Post subject: Re: Identity Column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Vedran (Who.Cares@who.knows.com) writes:
> Is it possible to set the indentitiy flag for a column by simply using
> alter table/alter column in SQL 2000 and SQL 2005 .

No. With the funny exception of SQL Server Compact Edition. (But that is
really an entirely different engine.)


--
Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: Identity Column 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Identity column question - Hi, Is there a way to drop the identity nature of a column programmatically (Tsql)? Thanks. AM

Table problem with identity column - I have a table with an identity column which already has 20,000 rows in it... something happened though.. nothings changed about the table as far as I can tell but now it will not let me insert a new row into the table... evne in the managment studio ...

How to Add Identity to Existing Column - Hi, I want to modify the column with Identity. But, i am getting the following error. ALTER TABLE <TableName> ALTER COLUMN <ColumnName> INT IDENTITY (10, 1) --Already 10 Values are inserted in Table. My Error: Msg 156, Level 15, State 1, L...

Altering a table's column to set it Identity Seed - Hi , I have an application which was intially not using the autonumbering feature in SQL2k5 and the primary key values were populated via a manually generated sequence numbering scheme. A lot of data went into these tables in this way. However this....

How to retrieve the value of the autonumber (identity) col.. - I am trying to retrieve the value of the autonumber field after adding and updating a record to a SQL Server 2005 database. I can't get it working, it always shows the value 'empty'. I've been through a lot of documentation which advises me to use ..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]