disktable.sql

来自「机械工业出版社《SQL Server应用开发实例教程》源代码」· SQL 代码 · 共 43 行

/*
   2001年4月6日 18:16:48
   User: 
   Server: JERRY
   Database: diskrent
   Application: MS SQLEM - Data Tools
*/

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Table1
	(
	disk_no bigint NOT NULL IDENTITY (1, 1),
	disk_name varchar(20) NULL,
	disk_language char(10) NULL,
	place varchar(20) NULL,
	remark varchar(50) NULL,
	supply_id int NOT NULL,
	unit_price money NULL,
	qnt bigint NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Table1 ADD CONSTRAINT
	DF_Table1_disk_language DEFAULT '中文' FOR disk_language
GO
ALTER TABLE dbo.Table1 ADD CONSTRAINT
	PK_Table1 PRIMARY KEY CLUSTERED 
	(
	disk_no
	) ON [PRIMARY]

GO
COMMIT