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
- 6224 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 |
How to disconnect from a sql server using mssql_close()?
What are the steps you will take to improve performance of a poor performing query?
How to change the password of a login name in ms sql server?
What are the kinds of subquery?
What are approximate numeric data types in ms sql server?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
How many columns can we include on clustered index ?
How to count groups returned with the group by clause in ms sql server?
What are the different methods available under sqlcommand class to access the data?
Tell me in brief how sql server enhances scalability of the database system?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the purpose of self join?
-
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)
