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 + -
显示快捷键?