Comments for fields or columns are added with the property comment.
In the script for creating a new table,
You can add comments by adding the comment attribute to the field definition script.
The sample code is as follows:
Create a table test (
Id int not null defaults to 0 Note' User ID'
)
If it is an artificial watch,
You can also use the command to modify fields, and then add annotation attribute definitions to add annotations.
The sample code is as follows:
Change form test
Change column id id int not null default value 0 Note' Test Table id'
It is known to add comments to fields or columns of a table.
So, how do you view the comments of all fields in an existing table?
You can view it with the command: show full columns from table.
Examples are as follows:
Displays the complete column of the test;