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

11 votes286 views2 answers
Sql between date range
SQL
1 vote303 views1 answer
Declare variables sql
SQL
0 vote332 views1 answer
Sqlcl format
SQL
3 votes332 views2 answers
How to force truncate a table in mysql
SQL
1 vote301 views1 answer
Show structure of table in sql
SQL
0 vote328 views1 answer
Check user sql password from command line
SQL
0 vote323 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote298 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote331 views1 answer
Postgresql find biggest table
SQL
3 votes262 views1 answer
Postgresql where current year
SQL