Query all tables in a specified database

/* Query all tables in the specified database */
Select count (*) from information_schema.tables where table_schema = 'mdm '/* database name */
Select T. table_name, T. table_collation from information_schema.tables t where T. table_schema = 'mdm '/* database name */

/* Query all columns in the specified table */
Select count (*) from information_schema.columns Col where col. table_schema = 'mdt'/* database name */and Col. table_name = 'account'/* Table name */
Select Col. column_name, Col. data_type, Col. column_type, Col. column_default, Col. column_key from information_schema.columns Col where Col. table_schema = 'mdt'/* database name */and Col. table_name = 'account'/* Table name */