These two, the auto incrementing field and the Index on any column are two
different things. what exactly is the requirement, the first one or the
second one.


-----Original Message-----
From: David Cameron [mailto:dcameron@i...]
Sent: Wednesday, July 31, 2002 3:19 AM
To: sql language
Subject: [sql_language] Re: Create a table with index


> If I understand the question, you need to create an 
> auto-increamenting 
> field.  In MySQL I used auto-increament fields.  In PostgreSQL, I use 
> sequences in a serial field, but Postgres automatically gives 
> each row a 
> unique OID (object identification number).

This depends on the database. For SQL Server indexes can be created on any
column. Check your documentation for your database, for SQL Server look in
SQL Books Online under CREATE INDEX.

regards
David Cameron
nOw.b2b
dcameron@i...