T-SQL to return a table's Key Coulmn(s)

[CrazyBishop]

I am writing a trigger and I need to have
the key field names of a table whose name
I am given returned.

i.e. I want to return "Order_ID" and "Detail_ID"
when I feed the T-SQL the Order_Detail table.

again for clarity I am not asking for

Select Order_ID, Detail_ID FROM Order_Detail.

Thanx.

 

[foxdev]

Try sp_helpconstraint.
Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org