Board index » delphi » How get primary keys from table ?

George Aligianis

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

How get primary keys from table ?

Quote
>How can I get information about primary keys in table ?

>I have Delphi 4.0 and SQL-Server 6.5.

for information use

sp_table tablename //can't use properly in delphi cos it returns multiple
result sets

for in code use the system tables eg sysconstraints and sysobjects.

George Aligianis

 
Koshmaniv Vladimi

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:How get primary keys from table ?


Hi

How can I get information about primary keys in table ?

I have Delphi 4.0 and SQL-Server 6.5.

Thanks

Other Threads

1. Primary key or not primary key.........

2. Getting the primary key index name.

3. Getting Primary Key fields of an ADO dataset...

4. API - Getting primary Key Def

5. Getting generated primary key

6. Getting primary key generated by trigger.

7. getting primary key of current record from DBGrid

8. getting table without index primary

9. Primary Keys from table

10. find primary key against database server table?