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 are sql servers used for?
What are the various editions of sql server 2017 that are available in the market?
List out the different types of locks available in sql server?
hi i gone though satyam interview. what is Acid Properties?
what is hash table
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
Explain SELF JOIN ?
Is mysql better than sql server?
two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship
Explain optimistic and pessimistic concurrency?
How to retrieve error messages using odbc_errormsg()?
Explain transaction server distributed transaction?
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)