Answer Posted / mallik

Unique Index and Unique Constraint are the same. They
achieve same goal. SQL Performance is same for both.

Add Unique Constraint
ALTER TABLE dbo.<tablename> ADD CONSTRAINT
<namingconventionconstraint> UNIQUE NONCLUSTERED
(
<columnname>
) ON [PRIMARY]

Add Unique Index
CREATE UNIQUE NONCLUSTERED INDEX
<namingconventionconstraint> ON dbo.<tablename>
(
<columnname>
) ON [PRIMARY]

There is no difference between Unique Index and Unique
Constraint. Even though syntax are different the effect is
the same. Unique Constraint creates Unique Index to
maintain the constraint to prevent duplicate keys. Unique
Index or Primary Key Index are physical structure that
maintain uniqueness over some combination of columns across
all rows of a table. It is a convenient way to enforce a
Unique Constraint for SQL Server.

what is the difference between delete and truncate commands? : Sql dba

1114

---

How do I install microsoft sql?

1112

---

Which join condition can be specified using on clause?

1009

---

what are the different tables present in mysql? : Sql dba

1036

---

What operators deal with null?

1153

---

What is primary key secondary key alternate key candidate key?

1085

---

Is sql better than excel?

1224

---

describe transaction-safe table types in mysql : sql dba

1052

---

what is self-join? : Sql dba

1236

---

What are all types of user defined functions?

1131

---

what is foreign key? : Sql dba

1105

---

How many functions are there in sql?

1092

---

Is id a reserved word in sql?

1186

---

what is the different between now() and current_date()? : Sql dba

1069

---

Explain the update statement in sql

1041

---