How to create gender column in SQL?

Question

Can anyone tell me how to create gender column in SQL?

Answer 1

Here is the syntax to create a gender column in SQL:

Create table table_name (

Gender Varchar (10) check (gender in ('Female','Male'))

Here we use CHECK constraint with GENDER column so that you cannot enter any entry other than Male or Female.

If you want to add a gender column to an already existing table:

ALTER TABLE TableName

                ADD CONSTRAINT myCheckConstraint CHECK (gender in ('Female','Male'))

If you want to learn SQL and writing SQL queries, I suggest this SQL server certification Course by Intellipaat that provides Instructor-led training, certification, and also job assistance.

Answer 2

To create gender column in SQL use the below query:

• ALTER TABLE tells the database which table you want to change
• ADD gender adds a new column called gender, which can store text values up to 10 characters long. You can change the size if you need to fit longer values.

ALTER TABLE TableName

ADD gender VARCHAR(10);