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

0 vote312 views1 answer
Sql pivot without aggregate
SQL
0 vote311 views1 answer
Nvl2 syntax
SQL
1 vote266 views1 answer
Sql update table remove spaces
SQL
0 vote285 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote322 views1 answer
Mysql workbench format date
SQL
0 vote286 views1 answer
MySQL import data from large CSV file
SQL
5 votes266 views6 answers
Sql add days to date
SQL
8 votes283 views1 answer
Oracle all_source package body
SQL
0 vote289 views1 answer
Sql bild in function
SQL
3 votes334 views1 answer
Mysql group_concat distinct
SQL