Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Some KB pages for SHOW CREATE statements seem to me inaccurate:
https://mariadb.com/kb/en/show-create-table/
"Shows the CREATE TABLE statement that created the given table"
This is incorrect, because some details might not match: non-significant characters, comments, quotes, table options...
It is even less correct if the table was modified after creation (ALTER TABLE).
The same bug is also in the output of the HELP statements.
I think that, for each SHOW CREATE statement, the docs should say: "Shows a CREATE $what statement that can be used to recreate the $what".