Perform the following
steps to delete the metadata for a column in the current table:
Note: When you modify
or delete the metadata for a column in a table and that table is used
in a SAS Data Integration Studio job, you might also have to make
the same modifications to other tables in the job. For example, if
you change the data type of a column and that table is used as a source
in a job, then you need to change the data type of that column in
the target table and in the temporary work tables in the transformations
in that job.
|
|
Perform the following
steps to import column metadata that has been added to the metadata
server that is specified in your current connection profile:
|
|
Indexes are registered
automatically when using Register tables to register metadata about
existing tables. Indexes are imported correctly when import/export
is used. Update table metadata also updates indexes. See Maintaining Indexes.
|
|
Primary, foreign, and
unique keys are registered automatically when using Register tables
to register metadata about existing tables. Keys are imported correctly
when import/export is used. Update table metadata also updates them,
although currently it does not handle foreign key updates.
It is important when
working with foreign keys to include ALL of the tables that are related
in a single registration. Otherwise, foreign key relationships cannot
be maintained. See Maintaining Keys.
|
|
Some windows enable
you to change the default order of columns. Then, you can save that
new order in the metadata for the current table or file. If you can
save reordered columns before you exit the current window, SAS Data
Integration Studio displays a dialog box that asks whether you want
to save the new order.
|
|
You can sort the columns
in a table based on the value of any column attribute (such as Name
or Description) in either ascending or descending order. For example,
you can sort the columns in ascending order by name by clicking the
Name heading. To sort the columns in descending order by name, you
can click the same heading a second time.
|
|