title: How to get names of the table attributes?
body: <p>I am working Sql Server 2005
  My table name is Customer, the attributes are</p>
  
  <p>Orderid
  Customerid
  Customeraddress</p>
  
  <p>Wherein Customerid is the primary key and Orderid is the foreign key.</p>
  
  <p>I want to know the 
  primary key name, 
  foreign key name and 
  the table name where the foreign key exists as a primary key</p>
  
  <p>Is there any query to retrieve those names using a table name?
  Kindly please provide me the queries...Thanks in advance</p>