MySQL

/****** Object:  StoredProcedure [dbo].[CheckColumnExist]    Script Date: 03/25/2009 12:21:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[CheckIndexExist]
AS
DECLARE @TableName VARCHAR(100)
DECLARE @ColumnName VARCHAR(100)
DECLARE @Object_ID BIT
DECLARE @Column_ID BIT
DECLARE @ID  INT
DECLARE @Result INT
DECLARE @Count INT

SET NOCOUNT ON

SELECT * INTO #OBJ FROM sys.all_objects 
SELECT * INTO #COL FROM sys.all_columns
SELECT * INTO #IDX FROM sys.index_columns





DECLARE GetTableNColumn CURSOR FOR SELECT ID, Table_Name, Column_Name  FROM IndexReport ORDER BY Table_Name, Column_Name

OPEN GetTableNColumn
FETCH NEXT FROM GetTableNColumn INTO @ID, @TableName, @ColumnName 
WHILE @@fetch_status = 0
BEGIN
SET @Object_ID = (SELECT count(Object_ID) FROM #OBJ WHERE #OBJ.NAME =@TableName )
SET @Column_ID = (SELECT Column_ID FROM #COL WHERE Object_ID = @Object_ID and NAME = @ColumnName)
SET @Count = (SELECT 1 FROM #IDX WHERE object_id =  @Object_ID and column_id = @Column_ID)

IF(@Count=1)
	BEGIN
		UPDATE IndexReport SET IndexExists=1 where id=@ID
	END
ELSE
	BEGIN
		--UPDATE IndexReport SET IndexExists=0 where id=@ID
		UPDATE IndexReport SET DUMMYT =CONVERT(VARCHAR,@Object_ID) + ' ' + CONVERT(VARCHAR,@Column_ID) where id=@ID
	END

FETCH NEXT FROM GetTableNColumn INTO @ID,@TableName,@ColumnName
END
CLOSE GetTableNColumn
DEALLOCATE GetTableNColumn

--select * from  #obj
--select * from  #ind
--select * from  #cal

SET NOCOUNT OFF