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 vote251 views1 answer
Generate a random otp in sql server
SQL
1 vote199 views2 answers
Postgres copy table from one schema to another
SQL
1 vote216 views4 answers
Aggregate function in sql
SQL
0 vote216 views1 answer
Get clob size oracle
SQL
0 vote209 views1 answer
Mysql conf.d exampel
SQL
13 votes234 views3 answers
List all the tables in sql
SQL
0 vote213 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
2 votes201 views1 answer
Sql create database
SQL
0 vote193 views1 answer
How to check replication lag in mySQL
SQL
1 vote219 views1 answer
Oracle create as select
SQL