Breaking News: Grepper is joining You.com. Read the official announcement!

Enum in SQL Server

Perfect Peccary answered on August 6, 2021 Popularity 10/10 Helpfulness 3/10

answer Enum in SQL Server

Enum in SQL Server

Comment

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'
);

Popularity 10/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: sql sql-server

Link to this answer
Share Copy Link