First, Oracle
--Create TABLE test ( ID varchar2 (+) primary key not NULL, sort number, name varchar (200))--Field annotated comment on C Olumn test.id is ' id '; Comment on column test.sort is ' serial number ';--table plus comment comment on table test is ' Test table '
Two. Mysql
--Create TABLE test ( ID varchar ($) NOT NULL, sort int (one) Comment ' sort ', name varchar (comment ' name ')--table plus Note ALTER TABLE Test comment = ' Test table '
Three. SQL Server
--Create TABLE test ( ID varchar ($) primary key not NULL, sort int, name varchar (200),)--annotate field with exec Sp_addextende Dproperty n ' Test ', n ' serial number ', n ' user ', n ' dbo ', n ' table ', n ' Test ', n ' column ', n ' sort ';--table plus comment execute sp_addextendedproperty N ' Test ', n ' Test table ', n ' user ', n ' dbo ', n ' table ', n ' test ', NULL, NULL
Oracle, Mysql, SQL Server create tables and annotate tables and fields