Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2970
  • Last Modified:

How to make comment when create table by ERWin?

I am trying to use ERWin to create table for ORACLE, but I am not sure how to add comment for all column, I mean I hope all Logical column name is treated as comment for that column, does anyone help me, what can I do?
0
mikezang
Asked:
mikezang
1 Solution
 
sapnamCommented:
You can add comments to the table or to columns in the table.  The command for adding comment to tables is]
 COMMENT ON TABLE [schema.]table IS 'text'

The command for adding comments to columns in a table is
   COMMENT ON COLUMN [schema.]table.column IS 'text'

You can view the comments by using the data dictionary views

DBA_COL_COMMENTS     ALL_COL_COMMENTS     USER_COL_COMMENTS  - For Couimns
DBA_TAB_COMMENTS     ALL_TAB_COMMENTS     USER_TAB_COMMENTS - For Tables
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now