Adding User Comments

This feature provides a mechanism for entering comments about elements within a database. The comments can either be viewed only by the user who entered the comment (Local Comment), or by all users of the database (Shared Comment).

Comments can be entered for any of the following database elements:

·Databases

·Tables

·Fields

·Indices

·Views

·Stored Procedures

Creating Local and Shared Comments

A Local Comment is available for viewing/editing only by the user who entered the comment and is not shared by other users of the database. These comments are stored in a local file on the user’s machine.

A Remote Comment is available for viewing/editing by other users of the database and is stored in a table within the database.

Creating a local comment

1          Log into WinSQL and establish a database connection. For more information, see “Establishing a Database Connection.”

2          Open the element to which you wish to add a comment.

3          Ensure the Local Comments tab is selected:

4          Enter the comment in the text area.

Creating a remote comment

1          Log into WinSQL and establish a database connection. For more information, see “Establishing a Database Connection.”

2          Open the element to which you wish to add a comment.

3          Ensure the Remote Comments tab is selected:

4          Enter the comment in the text area.

5          If the WINSQLCM table does not yet exist, the following window displays, and you must click Create Table to continue:

 If the WINSQLCM table exists, the comment is entered.

Important note: Do not change the table or column names in the Table for Remote Comments window. Doing so will prevent the remote comments feature from functioning correctly.