What is data type for status column (active/inactive) in SQL server?

Question

0.00/5 (No votes)

See more:

I was trying to create a new table. I need to add a column name Status (^ Active/Inactive). I am confused which data type should I select!

What I have tried:

I did varchar. Am I correct? if not what would be the correct datatype.

Posted 8-Mar-21 8:15am

Member 15093506

Updated 8-Mar-21 8:58am

Add a Solution

2 solutions

Solution 2

For SQL Server and for a simple On/Off, Yes/No, Active/Inactive I might use bit - bit (Transact-SQL) - SQL Server | Microsoft Docs[^]
I always question myself when I limit something like this so I would possibly use a char(1) in case some one comes along with something like a "Pending" status (yes I've been caught out before)

Posted 8-Mar-21 8:58am

CHill60

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RedDk · Accepted Answer · 2021-03-08T08:26:00

Sure ... "status" being either active or inactive (two values of potential status value ... 0 = inactive, 1 = active (to be typical)).

This is what I call a "flag" (from QBASIC days) which is the same thing as True or False.

Look up Boolean operator somewhere (your choice of search engine).

varchar is typically a string value but you could use it in a case mode ("
zero" or "one").

I'm becoming too verbose about this so; yeah do whatever (and use the BOL as reference; that always helps because it has examples).

Now that I think about it, there's a datatype in TSQL called boole isn't there?