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
How do I debug a stored procedure in sql server?
What is 'Join' and explain its various types.
Do you know what is a with(nolock)?
What are relationships and mention different types of relationships in the dbms
What is difference between equi join and inner join?
what types of replication are supported in sql server? : Sql server database administration
What is table valued function and scalar valued functions?
What is sql server 2000 work load governor?
How to find the version of sql server? : sql server database administration
What are the types of ssrs?
What is instead of dml trigger?
List out a number of the wants to setup a SQL Server failover cluster?
What are different types of collation sensitivity?
what is spatial nonclustered index
What do you mean by collation recursive stored procedure?