Data Vault Administrator Guide

6.4.3
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1

Back Next

Column Definitions

Use the ssadesc utility to list the column definitions for a specified table, schema, or database. By default, the utility prints the definitions in the screen output. Optionally, ssadesc can generate a Microsoft Excel file with the column definitions listed.

The following columns are included in the definition list:

TABLE_CAT

TABLE_SCHEM

TABLE_NAME

COLUMN_NAME

TYPE_NAME

COLUMN_SIZE

DECIMAL_DIGITS

POSITION

IS_NULLABLE

The ssadesc utility uses the following syntax:

ssadesc [ <flags> ]
[-h (displays the help screen)]
[-e (creates Excel report file)]
[-d<name> (database name)]
[-r<dir> (temporary directory for log, report, and runtime files)]
[-s<name> (schema name)]
[-t<name> (table name)]
[-u UID[/PWD] (Data Vault user name and password)]

You can specify the flags in any order.

Data Vault Administration

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal