what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 79890 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pramod tiwari,mba-it,lpu
SQL Constraints-
Constraints are used to limit the type of data that can go
into a table.
Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).
We will focus on the following constraints:
•NOT NULL
•UNIQUE
•PRIMARY KEY
•FOREIGN KEY
•CHECK
•DEFAULT
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Where can you find the error log information? : sql server database administration
Do you know what is a linked server in sql server?
How do you drop an index?
What is precedence constraint?
What is buffer cash and log cache in sql server?
How can you list all the table constraints in a database?
Can we take the full database backup in log shipping?
Give main differences between "Truncate" and "Delete".
Can an entity have two primary keys?
Working with TLogs
How to verify the port number of the sql server?
What is the sql server agent?
What happens if strings are casted into wrong code pages in ms sql server?
What are different types of collation sensitivity?
What is the fastest way to permanently delete a 1 million row table named customers?
