Oracle

Adding Comments to a Table

Figo Kim 2006. 11. 27. 22:59
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
COMMENT ON TABLE employees IS 'Employee Information';

-  Related Views :
  ALL_COL_COMMENTS, USER_COLS_COMMENTS, ALL_TAB_COMMENTS, USER_TAB_COMMENTS

- Up to 400 bytes

ex) select * from user_tab_comments where table_name = 'EMPLOYEES'

TABLE_NAME TABLE_TYPE COMMENTS
EMPLOYEES TABLE Employee Information


'Oracle' 카테고리의 다른 글

SQL 1999 Syntax  (0) 2006.11.28
SQL 1999 Syntax  (0) 2006.11.28
Adding Comments to a Table  (0) 2006.11.27
Synonym Information  (0) 2006.11.27
Synonym Information  (0) 2006.11.27