Table comments and field comments
Comments in Oracle
For example, comment on column table name is' xxxx';-- Table comments
Comment on column table name. Field name is' xxxxx'-- Field comment
Comments in mysql
-- annotate when creating a table
CREATE TABLE zy.student_info (
NAME VARCHAR (20) NOT NULL COMMENT 'student name'
Kecheng VARCHAR (20) NOT NULL
Fenshu INT (10)
) ENGINE=INNODB DEFAULT CHARSET=utf8
Modify the comments of the table
Alter table test1 comment 'comments on modified tables'
View field comment
Show full columns from table name
