Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
Answer Posted / uma
Yes, it is possible to allow NULL values in a foreign key,
this property has a relation with the another property "ON
UPDATE/DELETE SET NULL".
It is also possible to define multiple constraints on a
single column.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Are resultset updatable?
Do you know the capabilities of cursors?
Which joins are sql server default?
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 are different types of data sources?
What stored procedure would you use to view lock information?
Explain the xml support sql server extends?
How to change the name of a database user?
Explain the third normal form(3nf)?
Ways to improve the performance of a SQL Azure Database?
what is unique and xaml nonclustered index
What is temporary table in sql server? Why we use temp table?
What are the dmvs?
What are the requirements for sql server 2016?
How to modify the underlying query of an existing view?