Check the Tools->Update Library Metadata task. It allows you to create a report of your libraries/tables according to what metadata shows, and report on the differences.
It generates code like this:
/* assign library using metaout=data */
/* resulting library shows all physical tables */
libname _temp meta library="My Library" metaout=data;
/* show report of changes that *would* be made */
proc metalib;
omr (library="My Library");
update_rule=(delete);
report;
noexec;
run;
libname _temp clear;