Indicate table/column status

Applies to: Dataedo 23.x (current) versions, Article available also for: 10.x, 24.x

Databases hold many tables and columns that are not used anymore, were never used, or are not used yet. Probably, there are many other cases that you can think of. Understanding the status of the field might be crucial and helpful when working with database and data. We advise documenting the status in a custom status field.

Here are guidelines for creating such custom field:

Custom field attributes:

  1. Type - Dropdown list (closed),
  2. Class - Status,
  3. Visibility - Tables, Columns, Procedures, Parameters, Terms,
  4. Definition - list of possible statuses (see below),

Here are suggested options available in the field, but you may define this field so that it works for your specific needs:

  1. Active
  2. Never used
  3. Deprecated
  4. Planned
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.