--假如有表card
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[employees]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[employees]
GOCREATE TABLE [dbo].[employees] (
[employeeid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO--执行如下语句
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.employees
DROP CONSTRAINT PK_employees
GO
COMMIT
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[employees]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[employees]
GOCREATE TABLE [dbo].[employees] (
[employeeid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO--执行如下语句
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.employees
DROP CONSTRAINT PK_employees
GO
COMMIT
解决方案 »
- 请教:SQL2005与SQL2000数据库的转换问题
- datetime 值越界 是怎么回事啊
- SQL Server2005有关开发的重要特点
- 一个存储过程问题!
- 请问如何获知SQL SERVER中的某个数据库或数据表是否已存在?
- 在XP上如何安装SQL SERVER 2000?
- 执行"EXEC master..xp_cmdshell..."后找不到相关文件,请大家帮忙解答
- 在Windows2003 webedition 下安装SQL Server2000的标准版,安装程序一直出不来,是什么回事???
- 一个关于数据表对比更新的问题
- 多数据库的统计问题
- 怎样用SQL实现??
- 这句sql怎么写?.....
alter table 表名 drop constraint 主键约束名
--再添加
alter table 表名 add constraint 主键约束名 PRIMARY KEY on (列名,...)
add constraint fKname primary key(字段名)