Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 140436 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
Comment,Datatypes are unlimited
What is the difference between getdate and sysdatetime?
What is sharding?
Explain the difference between cross join and full outer join?
How to set database to be single_user in ms sql server?
How to create hyperlink from returned sql query ?
How do I start sql server 2016?
Define ACID properties in a Database?
What is a partitioned view?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is the difference between ddl and dml?
How can change procedure in sql server?
What is the maximum length of an alert name?
List some case manipulation functions in sql?
How to replace the Query Result 'Null Value' with a text ?
