hi friend! here the Query for finding how many column update in a table. select count(*) as no_of_column_update from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = {table name} AND TABLE_SCHEMA={database name}; hope it slove ur problem.