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
What is a transactions?
Does transparent data encryption provide encryption when transmitting data across the network?
What is the use of keyword with encryption. Create a store procedure with encryption?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How to use user defined functions in expressions?
What is the exact numeric data type in sql?
What are page splits? : SQL Server Architecture
How to provide login information for a new odbc dsn?
What are the two authentication modes in sql server?
Explain different types of locks in sql server.
Explain about Joins?
How to find the second highest salary of an employee?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Differentiate between ms sql server reporting services vs crystal reports?