.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Imran Ghani
Sohaib Khalid

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Why foreign key is not supported in temp tables ?

Posted By: Sweta m     Posted Date: April 16, 2012    Points:5   Category :Sql Server
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?

Author: Shweta             
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.


Author: Narayanan             
Posted Date: May 02, 2012     Points: 20   

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend