All columns along with flag for foreign key or not

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » All columns along with flag for foreign key...

All columns along with flag for foreign key or not

Rate Topic

Display Mode

Topic Options

Author

Message

Raghunath Garlapati

Posted Thursday, March 05, 2009 11:48 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 28, 2013 10:51 PM
Points: 42, Visits: 133

Hi

I need list of all columns in the database along with a flag or what ever which should indicate whether it is a key(foreign key) or not. Can any one please help on this

/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/

Post #669961

John H Marsh

Posted Friday, March 06, 2009 1:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 28, 2013 1:54 AM
Points: 1,325, Visits: 1,376

Hello,

You could probably build a formatted report using this code snippet as the starting point:-

Select
*
From
sys.columns SC
Left Join sys.foreign_key_columns FKC
On (FKC.parent_object_id = SC.object_id) And (FKC.parent_column_id = SC.column_id)

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Post #669994

Raghunath Garlapati

Posted Saturday, March 07, 2009 9:53 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 28, 2013 10:51 PM
Points: 42, Visits: 133

Thanq john actually i am sarching for any buit in function or view for this any ways thnq for the reply

/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/

Post #671059

GilaMonster

Posted Sunday, March 08, 2009 1:58 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

grngarlapati (3/7/2009)

Thanq john actually i am sarching for any buit in function or view for this any ways thnq for the reply

The views that John used in his query are built-in system views. There's no view of function that, by itself, will give you what you want, you'll have to build a query up using sys.columns and sys.foreign_key_columns.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #671079

« Prev Topic | Next Topic »

Permissions