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
- 9612 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 |
Where are stored procedures in sql server?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is ems sql management studio? : sql server management studio
What command must you use to include the not null constraint after a table has already been created?
Name few of the dcl commands in sql?
Explain “@@rowcount” and “@@error” in sql server?
Do you know sql server 2008 backup compression?
What does it mean to invest in the index?
What is BCNF? How is it better than 2NF & 3NF?
What is efficiency data?
How to delete duplicate records based on single column from a table?
0 Answers Petranics Solutions,
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
-
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)
