You can use the update
table metadata feature. This feature compares the columns, keys and
indexes in a physical table to the columns, keys, and indexes that
are defined in the metadata for that table. If column, key or index
metadata does not match the columns, keys, or indexes in the physical
table, the metadata is updated to match the physical table.
For existing tables,
the update table metadata feature adds new columns, keys and indexes,
removes deleted columns, keys, and indexes, and records changes to
all of the column, key, and index attributes. When you select and
run this feature against one or more tables simultaneously, the update
log lists which tables were successfully updated and which failed.
The update table metadata
feature uses the following resources:
-
the current metadata server and
the SAS Application Server to read the physical table
-
the current metadata server to
update the metadata to match the physical table