createdemo.sql

来自「db library 读写数据库」· SQL 代码 · 共 26 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_dblib]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[test_dblib]
GO

CREATE TABLE [dbo].[test_dblib] (
	[ch] 	[char] 		(10) NULL ,
	[vch] 	[varchar] 	(50) NULL ,
	[nch] 	[nchar] 	(10) NULL ,
	[_int] 	[int] 		NULL ,
	[_bit] 	[bit] 		NULL ,
	[_dec] 	[decimal]	(18, 4) NULL ,
	[_num] 	[numeric]	(18, 2) NULL ,
	[_mon] 	[money] 	NULL ,
	[_flt] 	[float] 	NULL ,
	[_sint] [smallint] 	NULL ,
	[_smon] [smallmoney] 	NULL ,
	[_real] [real] 		NULL ,
	[_txt] 	[text] 		NULL ,
	[_tint] [tinyint] 	NULL ,
	[_date] [datetime] 	NULL ,
	[_nvch] [nvarchar] 	(50) NULL ,
	[_sdate] [smalldatetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO