Page 1 of 1
Tables schema, definitions in D6
Posted: Wed 05 Apr 2006 10:29
by Frank626
How can I get tables and columns full definitions /schema in delphi6 with MyDAC –components?
Posted: Wed 05 Apr 2006 11:20
by Antaeus
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.
Thank You!
Posted: Wed 05 Apr 2006 18:02
by mydac4std
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 ...