if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[wstqf621]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[wstqf621]
GOCREATE TABLE [dbo].[wstqf621] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[pid] [int] NULL ,
[item1] [smalldatetime] NULL ,
[item2] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item3] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item4] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item5] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO以上SQL是用企业管理器里的表A,鼠标右键,《所有任务》《生成SQL脚本》获得的,表A中的id是主键,自动编号,而且是有“黄色小钥匙”图标的。
想用以上SQL创建一个同样结构,名字不同的表,生成的新表唯独缺少黄色小钥匙,请问如何解决呢?先谢谢大家乐。
drop table [dbo].[wstqf621]
GOCREATE TABLE [dbo].[wstqf621] (
[id] [int] IDENTITY (1, 1) NOT NULL Primary key,
[pid] [int] NULL ,
[item1] [smalldatetime] NULL ,
[item2] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item3] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item4] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item5] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
drop table [dbo].[wstqf621]
GOCREATE TABLE [dbo].[wstqf621] (
[id] [int] IDENTITY (1, 1) NOT NULL Primary key,
[pid] [int] NULL ,
[item1] [smalldatetime] NULL ,
[item2] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item3] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item4] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item5] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
drop table [dbo].[wstqf621]
GOCREATE TABLE [dbo].[wstqf621] (
[id] [int] PRIMARY KEY IDENTITY (1, 1) NOT NULL ,
[pid] [int] NULL ,
[item1] [smalldatetime] NULL ,
[item2] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item3] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item4] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[item5] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
再生成脚本就有了