Tables schema, definitions in D6

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Frank626

Tables schema, definitions in D6

Post by Frank626 » Wed 05 Apr 2006 10:29

How can I get tables and columns full definitions /schema in delphi6 with MyDAC –components?
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 05 Apr 2006 11:20

You can get list of table names in database using procedure MyConnection.GetTableNames(). To get field definitions you should execute EXPLAIN `TableName` command using MyQuery. Please see MySQL Reference Manual for more information.
Top
mydac4std
Posts: 13
Joined: Mon 20 Feb 2006 19:05

Thank You!

Post by mydac4std » Wed 05 Apr 2006 18:02

Thank you for your tips!

EXPLAIN works fine, but it does not show the COMMENT -field.
According your hint I tried
SHOW ALL COLUMNS
and that was what I was looking for!

Any way, without your hint ...
Top
Post Reply

Return to “MySQL Data Access Components”