Query used to create this table - show create index statements

Issue #356 resolved
Nicholas Schild created an issue


It would be great if the "Query used to create this table" section included the "create index" statements. It would make it a lot easier to have access to the whole table schema vs dropping the table, only to find out that you forgot to note how the indexes were constructed.

Comments (4)

  1. phpLiteAdmin repo owner

    You can export the table as SQL to get the whole SQL to recreate the schema. If you don't want the data in the dump, uncheck the "Export with data" checkbox.

    • click on the table on the left
    • click on the export tab
    • make sure "SQL" is selected
    • make sure "Export with structure" is selected
    • uncheck "Export with data" as needed
    • click Export
  2. Log in to comment