Return
-
Title
Schema Browser table column attributes representation. -
Description
Schema Browser shows the following table column attributes. What are the following attributes of columns in a table for and how they are used in the database table?
Histogram
Num Distinct
Encryption Alg
Salt
Seq/Trigger
-
Resolution
Histogram – Obtained from HISTOGRAM column of SYS.USER_TAB_COLUMNS view
Num Distinct - Obtained from NUM_DISTINCT column of SYS.USER_TAB_COLUMNS view
Encryption Alg – Obtained from ENCRYPTION_ALG column of SYS.USER_ENCRYPTED_COLUMNS view
Salt - Obtained from SALT column of SYS.USER_ENCRYPTED_COLUMNS view
Seq/Trigger – Represents a trigger/sequence pair created on the column