The procedure
updates all table definitions that are associated with the specified
SASLibrary object. The affected metadata objects include PhysicalTable,
Column, Index, PrimaryKey, ForeignKey, UniqueKey, and KeyAssociation,
with the following exceptions:
-
PROC METALIB does not create UniqueKey
objects for data in Oracle.
-
PROC METALIB does not create Index,
PrimaryKey, and ForeignKey objects for external databases that are
accessed with the
SAS/SHARE server.
-
PROC METALIB does not create metadata
for indexes on which expressions are defined. When an expression is
defined on an index, the index is ignored. Table metadata is created
without metadata for the index.
Note: The maximum length for index
names that can be registered by PROC METALIB is 256 characters. However,
other components of SAS or the DBMS might enforce a shorter length,
causing the name to be truncated.
For more information
about these metadata objects, see their descriptions in
SAS
Metadata Model: Reference.