priyakumari95
New member
Hello Dear,
Please Tell Me What are the constraints available in SQL ?
Please Tell Me What are the constraints available in SQL ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
constraints available in SQL ?
- Thread starter priyakumari95
- Start date
Martin smith
New member
There are 2 types of constraints in SQL.
1. Column Level Constraints : Limits only column level data
2. Table Level Constraints: Limits total table data.
1. Column Level Constraints : Limits only column level data
2. Table Level Constraints: Limits total table data.
Astrologer Mahendhar
New member
NOT NULL - Ensures that a column cannot have a NULL value.
UNIQUE - Ensures that all values in a column are different.
PRIMARY KEY - A combination of a NOT NULL and UNIQUE.
FOREIGN KEY - Uniquely identifies a row/record in another table.
Top Indian Astrologer in Canada | Indian Astrologer in Toronto | Top Astrology Services in Canada | Top Indian Astrologer in Toronto | Horoscope Reading Services in Canada
UNIQUE - Ensures that all values in a column are different.
PRIMARY KEY - A combination of a NOT NULL and UNIQUE.
FOREIGN KEY - Uniquely identifies a row/record in another table.
Top Indian Astrologer in Canada | Indian Astrologer in Toronto | Top Astrology Services in Canada | Top Indian Astrologer in Toronto | Horoscope Reading Services in Canada