Details

    Description

      Add support for Oracle's way of adding comments to tables, views, materialized views, columns, etc.

      Syntax and Semantics for Oracle's COMMENT statement can be found here: https://docs.oracle.com/database/122/SQLRF/COMMENT.htm#SQLRF01109

      Attachments

        Activity

          f_razzoli Federico Razzoli added a comment - - edited

          This is supported by all major DBMSs, not just Oracle. The only exception is SQL Server, but it has a system stored procedure for this.

          Also, it is not just a compatibility feature. It allows to:

          • Avoid dropping and recreating an index just to add a comment;
          • Avoid repeating a column definition just to add a comment: this is error prone;
          • Avoid granting a user ALTER privilege just because we want it to be able to add comments;
          • Similarly, avoid granting ALTER ROUTINE, that allows to change the SECURITY clause.

          Dataedo CEO stated in a webinar that their tool doesn't add comments to MySQL because they don't want to use ALTER TABLE.

          f_razzoli Federico Razzoli added a comment - - edited This is supported by all major DBMSs, not just Oracle. The only exception is SQL Server, but it has a system stored procedure for this. Also, it is not just a compatibility feature. It allows to: Avoid dropping and recreating an index just to add a comment; Avoid repeating a column definition just to add a comment: this is error prone; Avoid granting a user ALTER privilege just because we want it to be able to add comments; Similarly, avoid granting ALTER ROUTINE, that allows to change the SECURITY clause. Dataedo CEO stated in a webinar that their tool doesn't add comments to MySQL because they don't want to use ALTER TABLE.

          People

            Unassigned Unassigned
            pprkut Heinz Wiesinger
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.