Menu

#95 Implement a function to obtain SHOW CREATE TABLE like results

open
nobody
None
5
2012-02-23
2012-02-23
Jira Trac
No

MySQL provides [SHOW CREATE TABLE|http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html] which simply returns the *full* SQL which would create the complete schema of the table. This query is often used in performing backups and in Web frameworks. Currently several users have already asked for this feature (http://www.cubrid.org/forum/300136, http://www.cubrid.org/questions/242600\).

I have created a [BTS issue to CUBRID|http://bts1.nhncorp.com/nhnbts/browse/CUBRIDSUS-6996] for this, but I think this syntax will not be supported very soon. In the meantime, to support similar behavior in PHP (and in PDO maybe), we can implement a custom function, eg. cubrid_show_create_table(), until CUBRID provides native support. What do you think?

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.