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 / 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 |
How to insert stored procedure result into temporary table?
What happens to a trigger with multiple affected rows?
What is a mutating table error and how can you get around it?
Can we linked SharePoint to a SQL database?
0 Answers Sans Pareil IT Services,
Explain the flow of creating a cube? : sql server analysis services, ssas
Can you create a logon trigger in sql server 2005 express edition?
How can you see what type of locks used?
What are the pre-defined functions in the sql server?
what is the difference between procedure and function.
How to enter date and time literals in ms sql server?
What is the difference between executequery () and executeupdate ()?
What is sql server programming?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)