I have a table with a identity column called ID and there is also a Name column. What would be the most efficient way to prevent a name from being inserted that is already there?
make that column as a UNIQUE column.
Call me an idiot but, exactly how do I go about doing that?
To add a unique constraint to a table, use this sql syntax<BR><BR>alter table t add constraint UniqueCol unique(columnName)<BR><BR>you can drop the constraint with the statement<BR><BR>alter table t drop constraint UniqueCol
Thanks for the help. This board ROX!