unique varchar in field

2004-04-07 Thread Brad Tilley
Hello again, How do you make a field unique, but not have it as part of the primary key? For example, I have a 'computers' table that has a 'comp_id' field that's the primary key. It's an int that's auto-incremented with each new entry. The same table has a 'comp_serial' field. I want this

Re: unique varchar in field

2004-04-07 Thread Michael Stassen
Brad Tilley wrote: Hello again, How do you make a field unique, but not have it as part of the primary key? For example, I have a 'computers' table that has a 'comp_id' field that's the primary key. It's an int that's auto-incremented with each new entry. The same table has a 'comp_serial'