Aqua Data Studio



Aqua Data Studio. Aqua Data Studio is an integrated development environment (IDE) for data sources such as Microsoft Excel and databases. It integrates database management, database design, database administration, SQL programming, data management, and visual analytics into a single application software. Download Aqua Data Studio for free for 14-days, including all enterprise features enabled like Schema Synchronization, SQL support, analytics and more.

This tutorial will show you how to view and edit table and column comments using Aqua Data Studio.

In both options we will use the Server Panel, so open it by clicking the Servers tab (Fig. 1 [1]), or clicking Window -> Show/Hide Server Panel in the toolbar (Fig. 1 [2]), or by CTRL + ALT + F1 shortcut.

Fig. 1. Make Server Panel visible

Edit tables and columns comment

In the Server Panel expand Tables branch in your schema and find the table to view/edit comment. Right click on it and select either Table properties only view the comment, or Alter Table to edit them.

Fig. 2. [1] Alter Table, [2] Table Properties

In the new window, you will see table columns and its properties. To view a column's comments just click on it. Below column list, you should see properties list with comment field (Fig. 2 [1]). If you don’t see this window, use the anchor (Fig. 2 [2]) to slide it up. If you chose Alter Table this field will be editable.

Fig. 3. Columns comments in table properties

To view table comment you must switch from the General tab to the Comments tab. If you have modified comments remember to save changes by clicking on the Alter button.

Fig. 4. Table comment in table properties window

For some DBMS this might look a little different. For example in SQL Server column comments are in Extended Properties field (Fig. 4 [1]) and table comments are under Extended Properties tab (Fig. 4 [2]) instead.

Fig. 5. Comments in SQL Server connection

View Comments in an ER Diagram

You can view table and column comments in generated ER Diagram, although they won't be editable.In order to do this, right click on any single database/schema or any object in a schema in the Servers Panel and select Tools -> ER Diagram Generator.

Fig. 6. ER Diagram generator in context menu

In the new window, you can choose a specific schema, or set the Schema field to < All Schemas >. Select the object types which comments you want to view and objects to include. Make sure to check Include Comments box. Then click the Next button.

Aqua data studio 21

Fig. 7. ER Diagram Generator options

Studio

When ER diagram is generated, you can click on Display Comments button (Fig. 8 [1]) to show comments in bottom of table. To view column comment click on entity - comments are in Comments column (Fig. 8 [2]) in Object Properties (click it or press CTRL + ALT + F10 if it's not visible). You can find table comments there too by switching to Comments tab (Fig. 8 [3]).

Fig. 8. [1] Display Comments button, [2] Column comments in Object Properties,
[3] Table Comments tab

This tutorial will show you how to view and edit table and column comments using Aqua Data Studio.

In both options we will use the Server Panel, so open it by clicking the Servers tab (Fig. 1 [1]), or clicking Window -> Show/Hide Server Panel in the toolbar (Fig. 1 [2]), or by CTRL + ALT + F1 shortcut.

Fig. 1. Make Server Panel visible

Edit tables and columns comment

In the Server Panel expand Tables branch in your schema and find the table to view/edit comment. Right click on it and select either Table properties only view the comment, or Alter Table to edit them.

Data

Fig. 2. [1] Alter Table, [2] Table Properties

Downloads

In the new window, you will see table columns and its properties. To view a column's comments just click on it. Below column list, you should see properties list with comment field (Fig. 2 [1]). If you don’t see this window, use the anchor (Fig. 2 [2]) to slide it up. If you chose Alter Table this field will be editable.

Fig. 3. Columns comments in table properties

Aqua Data Studio Download

To view table comment you must switch from the General tab to the Comments tab. If you have modified comments remember to save changes by clicking on the Alter button.

Fig. 4. Table comment in table properties window

For some DBMS this might look a little different. For example in SQL Server column comments are in Extended Properties field (Fig. 4 [1]) and table comments are under Extended Properties tab (Fig. 4 [2]) instead.

Fig. 5. Comments in SQL Server connection

View Comments in an ER Diagram

You can view table and column comments in generated ER Diagram, although they won't be editable.In order to do this, right click on any single database/schema or any object in a schema in the Servers Panel and select Tools -> ER Diagram Generator.

Fig. 6. ER Diagram generator in context menu

In the new window, you can choose a specific schema, or set the Schema field to < All Schemas >. Select the object types which comments you want to view and objects to include. Make sure to check Include Comments box. Then click the Next button.

Fig. 7. ER Diagram Generator options

Aqua Data Studio 21

When ER diagram is generated, you can click on Display Comments button (Fig. 8 [1]) to show comments in bottom of table. To view column comment click on entity - comments are in Comments column (Fig. 8 [2]) in Object Properties (click it or press CTRL + ALT + F10 if it's not visible). You can find table comments there too by switching to Comments tab (Fig. 8 [3]).

Aqua Data Studio Downloads Free

Fig. 8. [1] Display Comments button, [2] Column comments in Object Properties,
[3] Table Comments tab