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_NORECOMPUT = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] go