这是生成表的脚本 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_EMPLOYEE_EMPLOYEEG_GROUP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[employee] DROP CONSTRAINT FK_EMPLOYEE_EMPLOYEEG_GROUP GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GROUPMAS_GROUPMAST_GROUP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[groupMaster] DROP CONSTRAINT FK_GROUPMAS_GROUPMAST_GROUP GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[group] GOCREATE TABLE [dbo].[group] ( [groupId] [bigint] IDENTITY (1, 1) NOT NULL , [schoolId] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [groupName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [groupComment] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO××××××××××××××××××××××× 我的查询语句是很简单的 select * from [group]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_EMPLOYEE_EMPLOYEEG_GROUP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[employee] DROP CONSTRAINT FK_EMPLOYEE_EMPLOYEEG_GROUP
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GROUPMAS_GROUPMAST_GROUP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[groupMaster] DROP CONSTRAINT FK_GROUPMAS_GROUPMAST_GROUP
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[group]
GOCREATE TABLE [dbo].[group] (
[groupId] [bigint] IDENTITY (1, 1) NOT NULL ,
[schoolId] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[groupName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[groupComment] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO×××××××××××××××××××××××
我的查询语句是很简单的
select * from [group]