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 votes287 views1 answer
Oracle sleep
SQL
1 vote307 views1 answer
Nvl postgres
SQL
0 vote263 views1 answer
Mysql installer no packages found
SQL
4 votes328 views3 answers
Mysql get column names from table
SQL
2 votes291 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote230 views1 answer
Oracle sysdba connect as another user
SQL
0 vote267 views1 answer
Online sql testing tool
SQL
0 vote275 views1 answer
Sql query to get column names and data types in sql server
SQL
3 votes241 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote263 views1 answer
Sql select first and last record of each group
SQL