CODEWITHSUNDEEP
sql-server
slao
slao

Reputation: 2086

SQL Server 2008 adding Check Values

I want to allow a column to accept only two values i.e. Open and Close statuses.How would I go through with it ?

CREATE TABLE Tasks(
ID INT IDENTITY(1,1),
Short_Name VARCHAR(25) NOT NULL,
DateCreated DATETIME NOT NULL,
DateModified DATETIME NULL,
CreatedBy INT NOT NULL,
ModifiedBy INT NULL,
Status VARCHAR(12) DEFAULT('Open') NOT NULL,
Description VARCHAR(255) NULL,
)

Upvotes: 0

Views: 197

Answers (1)

Anil Soman
Anil Soman

Reputation: 2467

Try this

CREATE TABLE Tasks(
    ID INT IDENTITY(1,1), 
    Short_Name VARCHAR(25) NOT NULL, 
    DateCreated DATETIME NOT NULL, 
    DateModified DATETIME NULL, 
    CreatedBy INT NOT NULL, 
    ModifiedBy INT NULL, 
    Status VARCHAR(12) DEFAULT('Open') NOT NULL, 
    Description VARCHAR(255) NULL, 
    CONSTRAINT chk_status_val CHECK(Status IN ('Open', 'Close'))
)

Upvotes: 4

Related Questions