Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database?
- 4 Answers
- 7285 Views
- I also Faced
- E-Mail Answers
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 is stretch database in sql server?
What is the rdl file?
How to receive output values from stored procedures?
Tell me the difference between clustered and non-clustered index?
What new changes are being made in SQL Server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain the steps to use transact-sql cursor?
Define self join?
How to call stored procedure using http soap?
How many columns can exist together per table?
What is sql injection? How to protect against sql injection attack?
How does normalization work?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is scalar user-defined function?
‘Order by’ is not allowed in a view how can you sort information from a view?
