Document TypeㅣTechnical Information
Category | Administration
Applicable Product Versionsㅣ6FS07, 6FS07PS, 7FS02, 7FS02PS
Document NumberㅣTADTI018
Overview
This guide explains how to add, modify, or delete separate descriptions (Comments) on tables in Tibero.
Method
Check View
SQL> desc USER_TAB_COMMENTS COLUMN_NAME TYPE CONSTRAINT ---------------------------------------- ------------------ -------------------- TABLE_NAME VARCHAR(128) TABLE_TYPE VARCHAR(9) COMMENTS VARCHAR(4000)
1. Create Table
$ tbsql tibero1/tmax SQL> create table comment_t(A) as select * from dual; Table 'COMMENT_T' created.
2. Check Comment (Before Adding)
SQL> SELECT table_name, table_type, comments FROM USER_TAB_COMMENTS WHERE comments IS NOT NULL; 0 row selected.
3. Add Comment to Table
SQL> comment on table comment_t is 'This is a comment test';
4. Check Comment (After Adding)
SQL> SELECT table_name, table_type, comments FROM USER_TAB_COMMENTS WHERE comments IS NOT NULL; TABLE_NAME -------------------------------------------------------------------------------- TABLE_TYPE ---------- COMMENTS -------------------------------------------------------------------------------- COMMENT_T TABLE This is a comment test 1 row selected.
5. Delete Comment (After Adding)
SQL> COMMENT ON table comment_t IS '';
6. Confirm Comment Deletion
SQL> SELECT table_name, table_type, comments FROM USER_TAB_COMMENTS WHERE comments IS NOT NULL; 0 row selected.