Setting Primary key to zero

Question

Post reply

Setting Primary key to zero

mashikoo

Ten Centuries

Points: 1188
More actions
October 11, 2010 at 10:12 am

#241516

How do I set primary key to zero and add a new set of data to my table? Any suggestion will be appreciated.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 1

Can you give more details about what you are trying to accomplish?

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 2

A primary key is the column(s) that uniquely identify each row. You don't set a PK to anything, you set the PK in each row to a unique value. That value is determined by the data, or it's a surrogate with something like NewID() or identity.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Are you talking about an identity column perhaps?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mashikoo Ten Centuries Points: 1188 More actions · Answer 4

I have some data currently in my table and I want to flush them and add a new set of data. So I thought setting the Primary key to zero will help. Any other suggestions will be be appreciated:-)

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

DELETE FROM <tablename>

or

TRUNCATE <TableName>

Both will remove all data from the table.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 6

If you have an identity column, DBCC CHECKIDENT will help you reseed the column. If you have other types of PKs, just add new data.

mashikoo Ten Centuries Points: 1188 More actions · Answer 7

mashikoo

Ten Centuries

Points: 1188

October 11, 2010 at 12:34 pm

#1235179

Thanks guys. It worked. Appreciate it