Retreive PK/AK (UNIQUE constraint) fields

[SteveDingle]

Hi,

I'm working on a project in Visual Foxpro where I need to gather certain information about a SQL Server database. Hoping someone can point me in the right direction.

I need to get the field(s) which are defined as the primary key and alternate key value so I can pre-process data before sending it to SQL Server.

Is there anyway I can do this (using ODBC connection)

Thanks
Steve

 

[smnetto]

U can get the pk in a table using:

sp_pkeys tablename


Sergio