create directory table.sql

来自「Delphi7数据库开发教程,包含该书21套实例」· SQL 代码 · 共 16 行

SQL
16 行
字号
//如果表已经存在,则删除
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Directory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Directory]
GO

//创建表
CREATE TABLE [dbo].[Directory] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AbsoluteIndex] [int] NULL ,
	[Text] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[DirLevel] [int] NULL ,
	[CreateDate] [datetime] NULL ,
	[CreateUser] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DirPassword] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?