Re: How start identity field at 100
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 6 Nov 2007 10:36:55 -0600
Set the seed to 100. If you are using the SQL Manager, you can alter there,
but be careful with live databases using this method.
With scripting, the method is:
CREATE TABLE TableWithIdentityColumn
(
MyID int IDENTITY(100,1) PRIMARY KEY
, SomeData varchar(2000) NOT NULL
)
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
*************************************************
| Think outside the box!
|
*************************************************
"Cirene" <test@xxxxxxxx> wrote in message
news:e3mKixIIIHA.5328@xxxxxxxxxxxxxxxxxxxxxxx
I have a table with the PK field defined as an identity field with the
increment of 1. How do I START the calculations at 100, rather than 1?
.
- References:
- How start identity field at 100
- From: Cirene
- How start identity field at 100
- Prev by Date: Re: Better way for dropdownlists
- Next by Date: Re: How start identity field at 100
- Previous by thread: How start identity field at 100
- Next by thread: Re: How start identity field at 100
- Index(es):
Relevant Pages
|
