Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 138619 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kannan g
Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null
| Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
What happens if null values are involved in arithmetic operations?
Can we write ddl in trigger?
Explain go command in sql server?
Explain query editor regions
In case you have filters in your report, when filters will be applied in cached report instance?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
what protocol both networks use? : Sql server database administration
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Issues related in upgrading SQL Server 2000 to 2005 / 2008
what are the important architecture components of SSRS?
Explain the types of indexes.
What is the Control Flow in SSIS
How to provide values to user defined function parameters?
What are dml (data manipulation language) statements in ms sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
