anchor.diff:         COMMIT;
       """
   
  -    vsql(delete_measurements_sql)
       vsql(delete_defdims_sql)
       vsql(delete_dims_sql)
       vsql(delete_defs_sql)
  
positive.code:             LEFT OUTER JOIN MonMetrics.Dimensions dims
                ON dims.dimension_set_id = defdims.dimension_set_id
         WHERE def.id = defdims.definition_id
         %s %s);
         COMMIT;
      """ % (retain_time, and_clause, or_clause)
  
      delete_defdims_sql = """
         DELETE FROM MonMetrics.DefinitionDimensions
  
negative.code:                         help=help_text)
  
      args = parser.parse_args()
  
      if args.limit and args.admin_tenant in args.limit:
          print "Pruning the admin project is not allowed!"
          sys.exit(1)
  
      before_counts = get_table_counts(MON_TABLES)
      prune_tables(args)
      display_pruning_result(before_counts)
  