Management Studio Foreign Key constraints don't show up.
-
We have several SQL 2008 R2 SP1 CU2 that I just noticed that Foreign keys are on tables but when you go to the table and click on Constraints they don't show up. Has anyone else noticed this?
Default Constraints and Check Constraints show up but Foreign Keys don't show up.
-
They're in the keys folder, and also have a different icon in the columns folder.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
SQL Kiwi (1/10/2012)
They're in the keys folder, and also have a different icon in the columns folder.
what app did you use to make the "tearing" with the drop shadow? I like the looks of that and will want to use it for some future examples.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell (1/10/2012)
what app did you use to make the "tearing" with the drop shadow? I like the looks of that and will want to use it for some future examples.SnagIt from TechSmith. Highly recommended.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
excellent, thanks Paul!
added to my toolbox.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
I see it now. You are right. Sorry for the thread.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply