Answer / 1

There is a clear difference between the 2. A unique
constraint defines what combination of columns has to be
unique. A unique index is just a way of making sure the
above is always valid. But it's possible to have a non-
unique index supporting a unique constraint. (if the
constraint is deferable = Only has to be valid at commit
time but is allowed to be broken in the middle of a
transaction)

Answer / varsha

A UNIQUE Key grantees Unique values to a column but does not sort the column data, whereas A UNIQUE Index grantees Unique values to a column and also sorts the column data.

Answer / 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.

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

Why use truncate instead of delete?

0 Answers  

---

What kind of join is join?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

What is difference between inner join and self join?

0 Answers  

---

What is gpt format?

0 Answers  

---

What is left inner join in sql?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

What are sql commands?

0 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---