创建数据、创建数据库表

实例：

USE [master] GO if exists(select 1 from master..sysdatabases where name='qc')   --判断数据库是否存在

drop database [qc] --存在删除数据库

GO CREATE DATABASE [qc] ON  PRIMARY  --创建数据库

( NAME = N'1', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\qc.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

 LOG ON ( NAME = N'1_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\qc_log.ldf' , SIZE = 1024KB , MAXSIZE = 12GB , FILEGROWTH = 10%)

GO

USE [qc]

GO

if exists(select 1 from  dbo.sysobjects where name = 'Table_1' ) --判断表是否存在

drop table [dbo].[Table_1]--如果存在删除表

GO CREATE TABLE [dbo].[Table_1]--创建表

(

 [id] [int] IDENTITY(1,1) NOT NULL  PRIMARY KEY, --主键、自增、编号

 [name] [nchar](10) NULL, --字段

)

ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_1', @level2type=N'COLUMN',@level2name=N'id' --创建字段说明

GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_1', @level2type=N'COLUMN',@level2name=N'name' --创建字段说明 GO