Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Why foreign key is not supported in temp tables ?
April 16, 2012
came across the question in this portal which says we cannot have foreign key constraint in temp table. can anyone knows the reason why it is not supported?
Posted Date: May 01, 2012 Points: 20
Temp table is temporary table and resides in memory. and there is no need for foreign key because you can add/edit/delete temp table anytime and the scope of the temp table of the execution of the stored procedure.
Posted Date: May 02, 2012 Points: 20
Check this link
Regards, Lakshmi Naraayanan.S
To post reply
Related Questions Related Questions
Find the foreign key in all the tables in a Sql Server Database
syntax or command for list of Tables
Swap DataSet Tables column as row and row as Column
SQL 2005, Pull data from 3 tables Query doubt
How to synchronize two tables in two different servers where primary key is auto numbered?
find the composite primary key in all the tables using sql server
How to create tables on .sdf files
What are the properties of the Relational tables?
Creating temp table using stored procedure
Select query to check existence of foreign key
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend