PL5ALcpm

1CREATE TABLE IF NOT EXISTS Names (
2  id INTEGER IDENTITY PRIMARY KEY,
3  name VARCHAR(16)
4) 
5     
6SELECT
7  IDENTITY_START
8FROM
9  INFORMATION_SCHEMA.COLUMNS
10WHERE
11  TABLE_NAME = 'NAMES'
12  AND COLUMN_NAME = 'ID' 
13     
14INSERT INTO OtherTable VALUES DEFAULT, IDENTITY(), 'A reference to Names table'