构建数据库

创建数据库的语句：

CREATE DATABASE Accounting
ON
  (NAME = 'Accounting',
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AccountingData.mdf',
   SIZE = 10,
   MAXSIZE = 50,
   FILEGROWTH = 5)
LOG ON
  (NAME = 'AccountingLog',
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AccountingLog.ldf',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB);

GO

查询数据库构造信息：

EXEC sp_helpdb 'Accounting'

创建表：

USE Accounting
CREATE TABLE Customers
(
   CustomerNo    int         IDENTITY		NOT NULL,
   CustomerName  varchar(30)                NOT NULL,
   Address1      varchar(30)                NOT NULL,
   Address2      varchar(30)                NOT NULL,
   City          varchar(20)                NOT NULL,
   State         char(2)                    NOT NULL,
   Zip           varchar(10)                NOT NULL,
   Contact       varchar(25)                NOT NULL,
   Phone         char(15)                   NOT NULL,
   FedIDNo       varchar(9)                 NOT NULL,
   DateInSystem  date						NOT NULL
)

查询表信息：

EXEC sp_help Customers

修改数据库：

扩充数据库：

ALTER DATABASE Accounting
   MODIFY FILE 
   (NAME = Accounting,
    SIZE = 100MB)

修改表：

增加列：

增加一列：

ALTER TABLE Employees
   ADD 
      PreviousEmployer   varchar(30)   NULL

增加多列：

ALTER TABLE Employees
   ADD
      DateOfBirth     date       NULL,
      LastRaiseDate   date       NOT NULL
         DEFAULT '2008-01-01'

DROP语句：

同时删除两个表：

DROP TABLE Customers, Employees

删除数据库：

DROP DATABASE Accounting