Interested to Buy Any Domain ? << Click Here >> for more details...
Why foreign key column allowing null values even a parent
tables reference key column not having null value..
- 2 Answers
- 6107 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar
Foreign key consider only the values. According to null value is not a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sureshramsing@gmail.com
Yes foreign key column allows null values, if it is not having either primary key or not null constraints.
Foreign key just reference to the particular parent column only not for restrcting the data while insert or update. It verifies dependency at the time of delete only.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the difference between char and varchar2 datatype in sql?
Explain triggers?
Explain about Views?
How to select some specific rows from a table in ms sql server?
How you can get the list of largest tables in a database?
Write a sql query to delete duplicate records from a table called table1
What is the difference between a function and a stored procedure?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Is sql server is free?
Explain the usage of floor function in sql server.
What is the difference between grant and with grant while giving permissions to the user?
How do we rollback the table data in SQL Server
-
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)
