给表和列添加注释

在sql语句中我们可以在语句后加两个连接符,然后写些注释.

那怎么对表和列加一些注释呢.这样的注释也是非常有用的,因为我们看到一个表或列时光看名字顾名思义还是比较困难的.

1.对表加注释:

创建注释语法:

COMMENT ON TABLE table_name IS 'comment text';

查找注释语法:

SELECT comments FROM user_tab_comments WHERE table_name = 'ANAME' --注意引号中的表名一定要大写.

以表arwen为例:

COMMENT ON TABLE arwen IS 'this table include info about arwen';--添加注释

SELECT comments FROM user_tab_comments WHERE table_name = 'ARWEN';--查找注释信息

2.对列加注释：

语法:

COMMENT ON COLUMN table_name.column_name IS 'comments text';

SELECT comments FROM user_col_comments WHERE table_name = 'ANAME' AND column_name = 'ANAME';

以表arwen中的列ename为例:

COMMENT ON COLUMN arwen.ename IS 'the person name';

SELECT comments FROM user_col_comments WHERE table_name = 'ARWEN' AND column_name = 'ENAME';