Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 1 Answers
- 9652 Views
- I also Faced
- E-Mail Answers
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 delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
What is the difference between set and select?
What is database black box testing?
Explain features of analysis services?
How many .ndf files can we create in Sql server 2005?
What is a schema in ms sql server 2005?
How to test subquery results with the exists operator?
How can i change the column name.
13 Answers HCL, Yardi Software,
What are the different types of join?
What is the significance of master, tempdb and model databases?
How to create an inline table-valued function?
What is database isolation in sql server? : sql server database administration
-
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)
