sqlserver里是这样操作的，先删除索引，在加索引，删除操作很顺利,但是建索引报错："
消息 1912，级别 16，状态 1，第 3 行无法对 表 'dbo.EPI_JZJL' 继续执行索引 DDL 操作，因为它与已经对该对象进行的另一个并发操作冲突。该并发操作可能是对同一个对象的联机索引操作，也可能是另一个移动索引页(如 DBCC SHRINKFILE)的并发操作。"
下面是语句
[code=sql]
USE [SIPIS]
GO
/****** Object: Index [CHILDINFO_PART_PK] Script Date: 07/13/2016 17:15:16 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[EPI_CHILDINFO_PART]') AND name = N'CHILDINFO_PART_PK')
DROP INDEX [CHILDINFO_PART_PK] ON [dbo].[EPI_CHILDINFO_PART] WITH ( ONLINE = OFF )
GO
USE [SIPIS]
GO
/****** Object: Index [CHILDINFO_PART_PK] Script Date: 07/13/2016 17:15:16 ******/
CREATE UNIQUE NONCLUSTERED INDEX [CHILDINFO_PART_PK] ON [dbo].EPI_CHILDINFO_PARTINCLUDE
(FSTATUSTIME, FCREATEDEPT, FCREATEUSER, FIDCardType, FResidenceType31)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
USE [SIPIS]
GO
/****** Object: Index [EPI_CHILD_FCHILD] Script Date: 07/13/2016 17:17:37 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[EPI_CHILDINFO]') AND name = N'EPI_CHILD_FCHILD')
DROP INDEX [EPI_CHILD_FCHILD] ON [dbo].[EPI_CHILDINFO] WITH ( ONLINE = OFF )
GO
USE [SIPIS]
GO
/****** Object: Index [EPI_CHILD_FCHILD] Script Date: 07/13/2016 17:17:38 ******/
CREATE UNIQUE NONCLUSTERED INDEX [EPI_CHILD_FCHILD] ON [dbo].EPI_CHILDINFOINCLUDE(
IMUNO, NAME, BIRTH, SEX, REGTYPE, DWELLADDR, COMADDR, FATHERNAME, MOTHERNAME, MOBPHONE, OTHERPHONE, CARDDATE, BOOKINGDATE, ALLERGY, TABU, STATUS, TRANSTIME, REMARK, UPDATETIME, REGADDR, CID, STATIONCODE, BIRTHNO, ServerUpdatetime
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
[/code]
表的数据量有点多，一亿条数据。。。