Modify Oracle Table Field Descriptions

1 year ago
Benjamin Taylor
1 minute

To change the comments of table fields, you can use the following SQL statement:

COMMENT ON COLUMN table_name.column_name IS 'new_comment';

In this case, table_name is the name of the table to be modified, column_name is the name of the field to be modified, and new_comment is the new comment to be set. Example:

COMMENT ON COLUMN employees.employee_id IS 'Employee ID number';

This will change the comment of the “employee_id” field in the employees table to “Employee ID number”.

bannerAds