Board index » delphi » Primary Keys from table

Sven Lüdtke

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

Primary Keys from table

Hi there,

I'm trying to get the Primary- and Foreign-Keys of any table in a database.
I could not find any Delphi components or SQL-statements that can do this.

Any Hints ?

Thanks,

Sven

 

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

Re:Primary Keys from table


SG

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

Re:Primary Keys from table


U?ytkownik Sven Ldtke <lued...@wallace.ping.de> w wiadomo?ci do grup
dyskusyjnych napisa3:952910145.871...@erwin.dorf.wh.uni-dortmund.de...

Quote
> Hi there,

> I'm trying to get the Primary- and Foreign-Keys of any table in a
database.
> I could not find any Delphi components or SQL-statements that can do this.

> Any Hints ?

> Thanks,

> Sven

Hi,
If I understand you correctly, you should use Borland Database Desktop.
Greetings,
SG

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

Re:Primary Keys from table


Conor Boy

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

Re:Primary Keys from table


Maybe the DbiOpenIndexList function detailed in the BDE32.HLP would give you
what you're looking for, or at the least, some pointers in the right
direction.

HTH,

Conor

Quote
> Uytkownik Sven Ldtke <lued...@wallace.ping.de> w wiadomoci do grup
> dyskusyjnych napisa:952910145.871...@erwin.dorf.wh.uni-dortmund.de...
> > Hi there,

> > I'm trying to get the Primary- and Foreign-Keys of any table in a
> database.
> > I could not find any Delphi components or SQL-statements that can do
this.

> > Any Hints ?

> > Thanks,

> > Sven

Petio Tone

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

Re:Primary Keys from table


Hi, Sven.

If you want to get that information you must use BDE API function. For more
information look at DBE32.HLP.

Regards.
--
Petio Tonev
pto...@iname.com
www.i.am/ptonev , www.w3.to/tonevsoft

Other Threads

1. Interbase - Can't add primary key to table

2. How to get primary keys from table ?

3. How get primary keys from table ?

4. Modifing primary key after table created

5. Primary key or not primary key.........

6. find primary key against database server table?

7. Get primary key of an view/table

8. Finding Primary Key of a table

9. Sorting Paradox Tables With Indexed Primary Key Fields

10. Sorting a PDox Table that doesn't have a primary key