Need names of the table KEY FIELDS

[opticalman]

My front end is Visual Froxpro 8.0
My Backend is SQL EXPRESS 2005

I retrieve the table names with :

SELECT name, type FROM sysobjects WHERE type = 'U'

Once I have the table name I need a list of the KEY FIELDS for that table to make a local updateable cursor. Any suggestions are appreciated.

Jim Rumbaugh

 

[gmmastros]

Take a look here:

http://blog.sqlauthority.com/2007/0...bles-with-foreign-key-constraint-in-database/

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[opticalman]

Thank You George

I will report back after trying out some of the suggestions from the article.

Jim Rumbaugh