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

7 votes135 views1 answer
Query delete duplicates
SQL
0 vote116 views1 answer
Mysql update sequence with order by
SQL
0 vote125 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote124 views1 answer
Import database from a file using mysql commandline
SQL
24 votes123 views5 answers
List mysql users
SQL
2 votes136 views4 answers
Sql query interview questions
SQL
57 votes291 views6 answers
Mysql alter table add column
SQL
1 vote114 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote121 views1 answer
Sql contains numeric characters
SQL
0 vote125 views1 answer
Double in sql server example
SQL