November 7, 2002 at 1:27 pm
Hi all,
I just created a table in my prod environment, and the bus_name, bus_address, bus_city & bus_state have to be unique.
I also have a ID column, auto generated number. Can someone suggest a way to do this?
Do I create a unique index on these 4 columns, and make the ID the primary key to the table, or something else???
Thank you
November 7, 2002 at 1:55 pm
I agree, that would be your best plan.
November 7, 2002 at 1:55 pm
That should be a good idea.
November 7, 2002 at 2:05 pm
Another thumbs up from me....
November 7, 2002 at 2:06 pm
Thank you, everyone
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply