Tuesday, June 30, 2009

Show Full Database Schema (mysql) via Coldfusion

A lovely gem I just invented:


DATABASE SCHEMA:

<cfquery name="gettables" datasource="#request.pmdb#">
    show tables
</cfquery>

<cfloop query="gettables">
       
    <cfquery name="getcreate" datasource="#request.pmdb#">
        show create table #gettables["#gettables.columnlist#"]#
    </cfquery>
    <br /><br />
    <cfoutput>
        <div style="font-size:16px;font-weight:bold;">#getcreate.table#</div>
        <div style="font-size:12px;">#REPLACE(getcreate["create table"],request.NL,"<br />","ALL")#</div>
    </cfoutput>

</cfloop>


Good wrap!