SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_DEFAULT, IS_NULLABLE, EXTRA  FROM information_schema.columns WHERE table_schema = 'nombreBaseDatos';