Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139680 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / taru mathur
a constraint refers to a condition or a check that is
applied to a coloumn(field)or a set of coloumns in a table.
Their are mainly five types of constarints:
1. UNIQUE CONSTRAINT
2. PRIMARY KEY CONSTRAINT
3. DEFAULT CONSTRAINT
4. CHECK CONSTRAINT
5. FOREIGN KEY CONSTRAINT
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What are the purposes and advantages stored procedure?
What is the difference RDBMS and Graph Database?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to rebuild indexes with alter index ... Rebuild?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How do I start sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain about nested stored procedure?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
what stored procedure would you use to view lock information? : Sql server administration
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is a result set object returned by odbc_exec()?
Define compound operators?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How is sql used in sql server?
