How do I SHOW CREATE TABLE in CUBRID?
MySQL provides SHOW CREATE TABLE syntax which shows the CREATE TABLE statement that creates the given table including all its CONSTRAINTS and INDEXes. How do I obtain the same information in CUBRID?
Edit: I need an SQL solution so that I can execute the query in scripting language such as PHP. So, CUBRID Manager solution is not exactly what I am looking for.
Considering that $object_name = 'stadium', the following will be the output.
CREATE TABLE stadium( code INTEGER NOT NULL, nation_code CHAR NOT NULL, name VARCHAR(50) NOT NULL, area NUMERIC, seats INTEGER, address VARCHAR(100), CONSTRAINT pk_stadium_code PRIMARY KEY (code) );
Does anyone know pure PHP solution?