book.sql

来自「POWERBUILDER+SQLSERVER数据库应用系统开发与实力源码 图书」· SQL 代码 · 共 14 行

CREATE TABLE [dbo].[book] (
	[book_id] [int] IDENTITY (1, 1) NOT NULL ,
	[book_code] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[book_title] [char] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[book_author] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[book_press_code] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[book_category] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[book_totalnum] [int] NULL ,
	[book_outnum] [int] NULL ,
	[book_shelf] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[book_abstract] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO