how do i print out the sql i used to create my table in phpmyadmin

[mrsaywho]

how do i print out the code used to make my table.. you know some thing that looks like....

CREATE TABLE departments (
    department_id INTEGER NOT NULL, 
    name VARCHAR(100), 
    chief_id INTEGER, 
    parent_department_id INTEGER, 
    PRIMARY KEY (department_id), 
    UNIQUE (name), 
    FOREIGN KEY(parent_department_id) REFERENCES departments (department_id)
)

[Doug G]

If you use mysql, one easy way it to use mysql_workbench.  You can right-click a table name in a database, choose create from the popup menu and see the create statement.