 --Run the script below to get table to drop
 SELECT 'Alter table '+TABLE_NAME + Char(13) + char (10) + 'Drop column '+COLUMN_NAME,
      TABLE_SCHEMA AS SchemaName
     ,TABLE_NAME AS TableName
     ,COLUMN_NAME AS ColumnName
 FROM INFORMATION_SCHEMA.COLUMNS
 where COLUMN_NAME IN ('mbl_audit_user', 'mbl_audit_date')
 ORDER BY
      SchemaName
     ,TableName
     ,ColumnName;


