Identity seed

[Fernando Poinho Malard]

Hello,

I'm generating a SQL Server 2000 database from Visio 2002 SR-1.
Some columns are Indentity typed but I would like to specify the Identity
Seed as 0 and increment as 1.

If I just select Identity type on Visio, it generates Indentity (1,1) which
is the default option...

I know I can edit the script before it goes out to SQL but I have a lot of
tables with this demand...

Anyway to do this by an easier way?
Is there any place to change from Identity(1,1) to Identity (0,1)?
Any registry key, template script?

Thanks,
Fernando.

 

[Scot Becker]

Hi Fernando,

I'm generating a SQL Server 2000 database from Visio 2002 SR-1.
Some columns are Indentity typed but I would like to specify the Identity
Seed as 0 and increment as 1.

If I just select Identity type on Visio, it generates Indentity (1,1) which
is the default option...

I know I can edit the script before it goes out to SQL but I have a lot of
tables with this demand...

Anyway to do this by an easier way?
Is there any place to change from Identity(1,1) to Identity (0,1)?
Any registry key, template script?

Sorry, there is no way to specify the seed and increment values other than
by manually editing the resulting DDL.

FYI,
Scot.
--
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.