--删除OCULAR3所有表索引
--USE OCULAR3
DECLARE cur_table CURSOR LOCAL FOR
	SELECT OBJECT_NAME(id), name FROM sysindexes WHERE name like N'IX_%'
OPEN cur_table
DECLARE @table NVARCHAR(100)
DECLARE @index NVARCHAR(100)
FETCH NEXT FROM cur_table INTO @table, @index
WHILE @@FETCH_STATUS = 0
BEGIN
	EXEC('DROP INDEX [' + @table + '].[' + @index + ']')
	FETCH NEXT FROM cur_table INTO @table, @index
END
GO

--删除当前数据库所有表约束
DECLARE cur_table CURSOR LOCAL FOR
	SELECT OBJECT_NAME(id), name FROM sysindexes WHERE name like N'PK_%'
OPEN cur_table
DECLARE @table NVARCHAR(100)
DECLARE @index NVARCHAR(100)
FETCH NEXT FROM cur_table INTO @table, @index
WHILE @@FETCH_STATUS = 0
BEGIN
	EXEC('ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @index + ']')
	FETCH NEXT FROM cur_table INTO @table, @index
END