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 |
What is row-level compre?
What extended events?
What is use of except clause?
What is the difference between UNION and UNIONALL?
5 Answers CarrizalSoft Technologies, CTS,
What is difference between line feed ( ) and carriage return ( )?
What is sql language?
How to verify the port number of the sql server?
What is join and name different type of joins?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How is foreign key related to primary key?
What do you understand by replication in sql server?
If a table does not have a unique index, can a cursor be opened on it?
Oracle (3253)
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)