Question

如何在SQL Server2008中用代码建库建表

Answer 1

CREATE DATABASE Sales
  ON 
  ( NAME = Sales_dat,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\saledat.mdf',
      SIZE = 10,
      MAXSIZE = 50,
      FILEGROWTH = 5 )
  LOG ON
  ( NAME = Sales_log,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\salelog.ldf',
      SIZE = 5MB,
      MAXSIZE = 25MB,
      FILEGROWTH = 5MB ) ;
  GO

  create table bas_role_tb (
   id_role              int                  identity,
   role_code            varchar(30)          null,
   role_name            varchar(60)          null,
   del_flag             tinyint              null default 0,
   oper_date            datetime             null default getdate(),
   id_user              int                  null,
   remark               varchar(600)         null,
   constraint bas_role_pk primary key (id_role)
)
go

Answer 2

如下示例：
--检验用户角色表(UA_Role)是否存在，若已存在则删除
if exists(Select * From SysObjects Where Name = 'UA_Role')
Drop Table [UA_Role]
go
--创建用户角色表(UA_Role)
Create Table [UA_Role]
(
--主键列,角色组编码
[cGroup_Id] int IDENTITY(1,1) Not Null,
--角色组名称
[cGroup_Name] VarChar(40) Not Null,
--角色组说明
[cGroup_Des] VarChar(60) Null,
CONSTRAINT [PK_UA_Role] PRIMARY KEY NONCLUSTERED ([cGroup_Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
go