Question

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

Answer 1

新建查询—写脚本(如下)—执行(F5)
use [master]
go

--校验数据库是否存在，若已存在则删除
if exists(select * from Sysdatabases where name='MYERP')
drop database [MYERP]
go

--创建MYERP数据库
Create DataBase [MYERP]
on(Name='MYERP',FileName='D:\个人编程学习\Data\MYERP.mdf',Size = 3mb,FileGrowth = 1mb)
Log On(Name = 'MYERP_Log',FileName = 'D:\个人编程学习\Data\MYERP_Log.ldf',Size = 1mb,FileGrowth = 1mb)
go

use [MYERP]
go
--检验公司表(Company)是否存在，若已存在则删除
if exists(Select * From SysObjects Where Name = 'Company')
Drop Table [Company]
go
--创建公司表(Company)
Create Table [Company]
(
--主键索引列,公司编码
[cComCode] int IDENTITY(1,1) NOT NULL,
--公司全称
[cComName] [nvarchar](140) NOT NULL,
--公司简称
[cComAbbName] [nvarchar](20) NOT NULL,
--公司电子邮箱
[cComEmail] [nvarchar](30) NULL,
--公司地址
[cComAddress] [nvarchar](140) NULL,
--备注说明
[cComMemo] [nvarchar](240) NULL,
CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED
(
[cComCode] 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