Export table reference

Mary Bonney's profile image Mary Bonney posted 10 years ago in Feature discussion Permalink
Recently a possible feature came to mind which I don't believe Heidi has now but might be useful.

I keep a printed record of my databases so that I can reference them when programming and I thought it might be useful to export a table's definition, either as tab- or comma-separated values, or Excel. The export would simply show the view that you see in the table's BASIC tab: name, datatype, length, etc. Once in your printing program, you could easily delete any unwanted text.

Not a difficult addition, I would think, but quite handy.
[expired user #5008]'s profile image [expired user #5008] posted 9 years ago Permalink
Mary, I know this is old but what you can do is use the SQL Export facility and select create on Database() and Table(s) and select No Data and either to Clipboard or single .sql file.
This will give you your schema.

Please login to leave a reply, or register at first.