Titles/aliases

Applies to: 9.x (current) versions, Article available also for: 8.x, 7.x, 6.x, 5.x

What are titles

The purpose of many database objects changes as database evolves. However, you don't have to change the names of tables or other objects. Dataedo gives you the ability to add meaningful titles to most objects. This title will be added after the name on export. For instance: invoices_tab (Documents).

Titles are optional.

Tables/Views/Procedures/Functions

You can define a title for each table, view, procedure or function. You can do it in the Title field on object's form. Press Save button or Ctrl+S keys to save changes.

Table title

If you need to assign many titles at once it's more convenient to do it in a objects table. Select Tables folder in tree navigator to change tables titles. Update Title column of desired tables. Changes are saved instantly.

Table title

Columns

You can define a title for each column. You can edit title it in the Title field in columns table. Press Save button or Ctrl+S keys to save changes.

Column title

Obsolete

Quite often there are tables, columns, procedures etc. that are not used anymore because are replaced with something or abandoned. To avoid confusion and errors, you can use title column to mark such objects as obsolete. Just type in "OBSOLETE" text (or similar) in the title box.

Obsolete table

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.