Enum in SQL Server

USE WorldofWarcraft;

CREATE TABLE [users]
(
   ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
   username nvarchar(255),
   password nvarchar(255),
   mail nvarchar (255),
   [rank]  nvarchar (255) NOT NULL CHECK ([rank] IN('Fresh meat', 'Intern','Janitor','Lieutenant','Supreme being')) DEFAULT 'Fresh meat'
);

Source: stackoverflow.com

Similar codes

3 votes156 views2 answers
See mysql users ubuntu
SQL
0 vote146 views1 answer
Enable full text search mysql
SQL
3 votes138 views1 answer
Index using in query plsql
SQL
-1 vote153 views1 answer
Io
SQL
2 votes169 views1 answer
Sql OR
SQL
0 vote186 views2 answers
Search stored procedures by name
SQL
0 vote139 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
2 votes155 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote142 views1 answer
Python sqlalchemy orm to select null values
SQL
3 votes197 views1 answer
Sql datetime as date
SQL