Select statement

[lytheon]

Does anyone know how to make a select statement for this table:

/**********************************************************/
/*Table: FUNCTIE */
/**********************************************************/
DROP TABLE FUNCTIE;
CREATE TABLE FUNCTIE ( FUNC_ID INT
, FUNC_NAAM VARCHAR(64)
, FUNC_NAAM_NS VARCHAR(64)
, FUNC_ACTIEF_BL SMALLINT
, PRIMARY KEY (FUNC_ID)
) TYPE=INNODB;

which shows the data_type, data_length, constrain_type and column_id?

 

[QatQat]

show create table Functie;

Bye

Qatqat

Life is what happens when you are making other plans.