how can i find out the primary key

[saurabh]

how can i find out the primary key of the table using ASP..using recordset......

 

[swilliams]

If you are using a relational database (eg Access or SQL Server) one of the system tables will hold this information.
If you cannot find the table where this is held (I have had a quick look and I cannot see it!!!), create your own table and query this table.

Simon

 

[saurabh]

hi simon,

I actually meant to find the primary key in the table being referenced in the ASP script.

Is there a way to find out the PK of the table I am querying in ASP.