MySQL Forums
Forum List  »  General

Retrieve Data and Index Directory of table
Posted by: J Jorgenson
Date: April 15, 2014 03:38PM

How do I find the data and index directory of an existing table within the database?

Is there any alternate method besides parsing the output from 'Show Create Table' ?

Is there any location within the information_schema that provides the options from the original table Create SQL?

How about table create options for partitioned tables, like "index directory" of each partition?

I'm looking for a programmatic method to retrieve the table create options, like 'DELAY_KEY_WRITE' or 'DATA DIRECTORY'.

Options: ReplyQuote


Subject
Written By
Posted
Retrieve Data and Index Directory of table
April 15, 2014 03:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.