Sql Server 创建表的语句

 

create table threemap (
   threemap_id          varchar(50)          not null,
   threemap_identity_id int                  identity(1,1),
   threemap_name        varchar(200)         null,
   threemap_model_name  varchar(50)          null,
   threemap_parent_id   varchar(50)          null,
   threemap_level       int                  null,
   area_type_id         int                  null,
   area_info_sort       int                  null,
   org_id               int                  null,
   threemap_is_enable   int                  null,
   threemap_map_id      int                  null,
   threemap_elder       varchar(50)          null,
   threemap_duty_police varchar(50)          null,
   threemap_create_time timestamp            null,
   threemap_update_time timestamp            null,
   threemap_reserve1    varchar(100)         null,
   threemap_reserve2    varchar(100)         null,
   threemap_reserve3    varchar(100)         null,
   constraint PK_THREEMAP primary key nonclustered (threemap_id)
)

在 SQL Server Management Studio 软件中执行sql 语句：

右边属于sql语句，然后点击