Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 140434 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manish nagar
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).
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What do you understand by hotfixes and patches in sql server?
Can we use trigger new in before insert?
which table keeps the locking information? : Sql server administration
What do mean by xml datatype?
What is an example of a primary key?
What is delete query?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How you can get a list of all the table constraints in a database?
Explain the different index configurations a table can have?
What is the New in SQL server 2008?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What type of locking occurs during the snapshot generation? : sql server replication
What are commonly used mssql functions in php?
How do you delete duplicate rows in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
