Oracle、Mysql、SqlServer建立表和給表和欄位加註釋

標籤：

一、Oracle

--建立表create table test (  id varchar2(200) primary key not null, sort number,  name varchar(200))--欄位加註釋comment on column test.id is ‘id‘; comment on column test.sort is ‘序號‘;--表加註釋comment on table test is ‘測試表‘

 二.Mysql

--建立表create table test (  id varchar(200) not null, sort int(11) comment ‘排序‘, name varchar(200) comment  ‘名稱‘,)--表加註釋alter table test comment =‘測試表‘

三.SqlServer

--建立表create table test (  id varchar(200) primary key not null, sort int, name varchar(200),)--給欄位加註釋EXEC sp_addextendedproperty N‘test‘, N‘序號‘, N‘user‘, N‘dbo‘, N‘table‘, N‘test‘, N‘column‘, N‘sort‘;--表加註釋EXECUTE sp_addextendedproperty N‘test‘, N‘測試表‘, N‘user‘, N‘dbo‘,N‘table‘, N‘test‘, NULL, NULL

 

Oracle、Mysql、SqlServer建立表和給表和欄位加註釋