Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database?
Answer Posted / siva
Hi,
You can place the foreign key column in each table to allow
nulls. And insert values.
But I am still worried a lot about deletion of the values
from these tables ?
Plz post your comments
Regards,
Subbu
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are scalar functions in sql?
What is the difference between Triggers and Stored Procedure?
Explain in brief how sql server enhances scalability of the database system?
What is tempdb database? : SQL Server Architecture
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are the restrictions that views have to follow? : SQL Server Architecture
What is field in algebra?
What is always encrypted?
Explain about the command-line tool SQLCMD?
What is the difference between Clustered and Non-Clustered Index?
How to transfer a table from one schema to another?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Give an example of SQL injection attack ?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is data file in computer?