tag:blogger.com,1999:blog-9075786158122089104.post5024735513795673822..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Very useful Catalog View in SQL Server 2005:Ritesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-9075786158122089104.post-66969588067896435162009-06-16T19:41:02.772+05:302009-06-16T19:41:02.772+05:30you are welcome alwaysyou are welcome alwaysRitesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-43663654016140408452009-06-16T19:38:55.983+05:302009-06-16T19:38:55.983+05:30Thanks for the PK/FK query!Thanks for the PK/FK query!Shaggyhttps://www.blogger.com/profile/00444119444312016807noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-24587926334679583242009-06-16T14:41:41.615+05:302009-06-16T14:41:41.615+05:30this one is also helpful to find PK and FK relatio...this one is also helpful to find PK and FK relationship... query is written by Paul Nielson:<br /><br /><br />select fko.name as [FK Name], fk.constraint_column_id as [Col Order], <br />fks.name + '.' + fkt.name as [FK table], pc.name as [FK column], rcs.name + '.' + rct.name as [PK table], rc.name as [PK column]<br /> from sys.foreign_key_columns fk<br /> -- FK columns<br /> join sys.columns pc <br /> on fk.parent_object_id = pc.object_id<br /> and fk.parent_column_id = pc.column_id<br /> join sys.objects fkt<br /> on pc.object_id = fkt.object_id<br /> join sys.schemas as fks<br /> on fks.schema_id = fkt.schema_id<br /> -- referenced PK columns<br /> join sys.columns rc <br /> on fk.referenced_object_id = rc.object_id<br /> and fk.referenced_column_id = rc.column_id<br /> join sys.objects rct<br /> on rc.object_id = rct.object_id<br /> join sys.schemas as rcs<br /> on rcs.schema_id = rct.schema_id<br /> -- foreign key constraint name<br /> join sys.objects fko <br /> on fk.constraint_object_id = fko.object_id<br /> --and fk.referenced_column_id = rc.column_id<br /> order by fko.name, fk.constraint_column_idRitesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-25375315210408986282009-06-16T08:43:12.235+05:302009-06-16T08:43:12.235+05:30Good to know that you figured it out :)Good to know that you figured it out :)Ritesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-29073259249716638192009-06-16T02:37:51.473+05:302009-06-16T02:37:51.473+05:30Figured it out.
I was looking in the sys tables w...Figured it out.<br /><br />I was looking in the sys tables when I should have been checking the information_schema<br /><br />INFORMATION_SCHEMA.KEY_COLUMN_USAGE contained the information I was seekingShaggyhttps://www.blogger.com/profile/00444119444312016807noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-92227515977664610032009-06-15T21:34:29.284+05:302009-06-15T21:34:29.284+05:30I am trying to find the table that contains the co...I am trying to find the table that contains the columns that are a part of primary or unique key constraints.<br /><br />I thought that sys.key_constraints would contain it, but I was apparently mistaken.<br /><br />Thanks!Shaggyhttps://www.blogger.com/profile/00444119444312016807noreply@blogger.com