TMyTable show CREATE

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

TMyTable show CREATE

Post by tlhawkins » Thu 31 Mar 2005 05:08

When in design mode I can right click on a TMyTable and get the SQL to create the table, is there a way to get that SQL at runtime?

Thanks
Top
Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 01 Apr 2005 06:08

You should execute SHOW CREATE TABLE
Top
tlhawkins

Post by tlhawkins » Sat 02 Apr 2005 16:17

That's funny, I thought it was some complicated thing. I didn't realize I could get it with an SQL statement.

Thanks!
Top
Post Reply

Return to “MySQL Data Access Components”