02-03-2016 10:34 AM
We have a requirement where we need to identify the tables which are not having comments added along with the data type while creating the tables.
`emp_id` double COMMENT 'decimal(11,0)'
We have around 15k tables.
I am planning to do it in shell script with iterating through the list of tables -> describe them -> grep for COMMENT
Is there any other better way to do this task ?
02-28-2016 01:43 AM