Unique constraint index

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mansoor Azam (mansoorb_at_shoa.net)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 16:00:35 +0500

When I add a unique key constraint to column in SQL 6.5 why does it also
create an index. e.g. In the table subaccounts I added a unique key
constraint for the column login and SQL creates an index with the name
UQ_SubAccounts_2__19 (UKC).

Does this also mean that there is no need to create an index for this
column?

thx

Mansoor

Relevant Pages

  • Re: SQL 2000 / ASP - unwanted mutiple records
    ... Is there a Unique key on the table in question? ... SQL Server ... would prevent additional duplicate rows if there is a unique PK. ... > The SQL table does not have any triggers, the Command object on ASP page ...
    (microsoft.public.data.ado)
  • Re: Problem with @@ERROR
    ... There are many problems with the existing error handling mechanisms in SQL ... Server 2000. ... > Violation of UNIQUE KEY constraint 'IX_myTable. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I SELECT IDENTITY on UPDATE?
    ... > I want to update one row and get the unique key of that row in one SQL ... The reason why I prefer one SQL statement is that we are ... And it has nothing to do with CPUs, ...
    (microsoft.public.sqlserver.programming)
  • Re: Update Table With Unique Constraint
    ... I still get the unique key constraint error. ... LEFT OUTER JOIN EmployeeExt EE ON E.EmployeeID = EE.EmployeeID ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • RE: limit records
    ... Tables in SQL have rows not records - a small word but an important difference! ... You certainly can use triggers to do this but you can also use constraints. ... unique key. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)