vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint:

CREATE TABLE dbo.QotD
   (KeyColumn int NOT NULL PRIMARY KEY,
    RefColumn int NOT NULL,
--  More column definitions
    CONSTRAINT FK_RefTab FOREIGN KEY (RefColumn)
                         REFERENCES   dbo.RefTab(RefTabKey),
--  More constraints
    CONSTRAINT UQ_RefColumn UNIQUE(RefColumn)
   );

Doesn't it count as answer #2?

I also took answer number 2. Forgot that you cannot specify an index directly in a create table statement. D'oh!

vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint:

CREATE TABLE dbo.QotD
   (KeyColumn int NOT NULL PRIMARY KEY,
    RefColumn int NOT NULL,
--  More column definitions
    CONSTRAINT FK_RefTab FOREIGN KEY (RefColumn)
                         REFERENCES   dbo.RefTab(RefTabKey),
--  More constraints
    CONSTRAINT UQ_RefColumn UNIQUE(RefColumn)
   );

Doesn't it count as answer #2?

vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint