<p>Hi I want to have two tables each have an INT "id" column which will auto-increment but I don't want either "id" columns to ever share the same number. What is this called and what's the best way to do it? Sequence? Iterator? Index? Incrementor?</p>

<p>Motivation: we're migrating from one schema to a another and have a web-page that reads both tables and shows the (int) ID, but I can't have the same ID used for both tables.</p>

<p>I'm using SQL Server 9.0.3068.</p>

<p>Thanks!</p>

I think using a
GUID
would be the most straightforward way, if I understand you correctly.
```
```
SELECT NEWID()
```
```