SHOW COLUMNS FROM `GA_ACCOUNTS_MT` LIKE 'user_id%';

SELECT  TABLE_TYPE,table_schema AS DBName,TABLE_NAME AS TABLE_NAME, 

table_rows AS QuantofRows, 

ROUND((data_length + index_length) /1024, 2 ) AS "DB Size in KB"  ,

ROUND((data_length + index_length) / 1024 / 1024, 1) AS "DB Size in MB" 

FROM information_schema.TABLES

 WHERE   table_schema = 'GOAUDITS' 

AND TABLE_TYPE='BASE TABLE'  AND TABLE_NAME LIKE 'GA_AUD%'

/*

IN ('GA_QUESTION_MT','GA_QUESTION_DT',

'GA_QUESTION_SCORE_MT',

'GA_QUESTION_SCORE_MT_TEMP',

'GA_QUESTIONPHOTO_MT',

'GA_QUEST_MULTICHOICE_DT',

'GA_QUESCHSMAP_TP',

'GA_QUESCONFIG_TP',

'GA_QUEST_ACTIONPLAN_DT',

'GA_QUEST_ACTIONPLAN_DT_ACT',

'GA_QUEST_MULTICHOICE_DT',

'GA_QUESTACTIONFIELDS_MT',

'GA_QUESTACTIONFIELDS_DT',

'GA_QUESTIMG_DT',

'GA_QUESTION_MT_PARENT_ZERO',

'GA_QUESTION_MT_TEMP'

)

*/

 -- AND (TABLE_NAME LIKE 'GA_AUD%'   OR  TABLE_NAME LIKE 'GA_QUE%' or TABLE_NAME LIKE  'GA_USE%' or TABLE_NAME LIKE  'GA_STORE%' or TABLE_NAME LIKE  'GA_CLI%')

ORDER BY TABLE_NAME DESC, (data_length + index_length) DESC;