Exporting Table Comments

To export table comments from RED, select Tools > Table and Column Comments > Export Table Comments.

The Table Comments Export pop-up window is displayed:

1. Type in the directory and file name of the export file or click the folder icon to navigate to the required directory.
2. Select or de-select the required export options.
   
   • Only export comments from tables with a Business Display Name - This option enables you to only process tables that have a Business Display Name (EUL) defined in the table's Properties screen. Clear the check box if you want to process all tables in your data warehouse. 
   • Only export comments that are not empty - This option enables you to only process tables that have comments defined in the Description field of the table's Properties screen. Clear the check box if you want to process all tables in your data warehouse.   
   • Only export comments from End User Layer (EUL) tables - This option enables you to only process tables that are visible to the end user. Clear the check box if you want to process all tables in your data warehouse. The visibility of table objects to end users in RED are set in Tools > Options > Object Types > Object Type End User Setting, refer to Object End User Setting for details.   

   All the above options are selected by default.

3. Click OK to proceed with the export. The Table Comments Export pop-up window displays the progress of your export. You can click Cancel to abort the process.
   
   
   
4. Once the export process is completed, the pop-window displays the processing time and the number of comments copied to the export file.
   
5. Click Close to exit the pop-up window. The Results pane displays a summary of the comments exported and confirms the successful completion of the export.
   
   
6. Use Microsoft Excel 2013 or Notepad to view/edit the exported comments.