Sunday, January 04, 2009

Adding Comments to Table and Columns

Command to add comments to a table

SQL> comment on table hr_employees is 'This table stores the employee details';

Comment added

Command to add comments to a table Column

SQL> -- Add comments to the columns
SQL> comment on column hr_employees.ssn
is 'Social Security of employee';

Comment added

No comments:

Post a Comment