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

1 vote215 views2 answers
Datetrunc hour snowflake
SQL
0 vote220 views1 answer
How to export only procedures mysql
SQL
0 vote240 views1 answer
Define a variable in mysql from select
SQL
-1 vote216 views3 answers
Create temp table in sql
SQL
0 vote216 views1 answer
Set column width in sqlplus
SQL
0 vote232 views2 answers
Sql stored procedure for access frontend
SQL
4 votes219 views3 answers
How to describe a table in sqlite3
SQL
1 vote212 views1 answer
Postgres regex remove special characters
SQL
0 vote210 views1 answer
Mysql delete from where like
SQL
0 vote214 views1 answer
Oracle step procedure
SQL