CREATE PROCEDURE drop_column 
@owner varchar (100) = 'dbo'
, @table sysname
, @col sysname
AS 

DECLARE @sql varchar (8000)
DECLARE @idx_name sysname
DECLARE @stat int
-- Make sure that such table/column exists

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
                        WHERE TABLE_NAME = @table 
                              AND TABLE_SCHEMA =@owner 
                              AND COLUMN_NAME = @col)
BEGIN 
	RAISERROR ('Invalid owner, table or column parameter', 16, 1)
  	RETURN 1
END

--Pick a moment while nr isn't looking, create a cursor of foreign keys, referencing the field 
--Loop through and drop all of them.
DECLARE cur_fks CURSOR FAST_FORWARD READ_ONLY TYPE_WARNING
FOR 
	select 'ALTER TABLE '+ object_name(fkeyid) +' DROP CONSTRAINT [' + object_name(constid) + ']'
        FROM sysreferences WITH (NOLOCK) WHERE object_name(rkeyid) = @table 
							and  @col  IN ( col_name(rkeyid, rkey1)
									, col_name(rkeyid, rkey2)
									, col_name(rkeyid, rkey3)
									, col_name(rkeyid, rkey4)
									, col_name(rkeyid, rkey5)
									, col_name(rkeyid, rkey6)
									, col_name(rkeyid, rkey7)
									, col_name(rkeyid, rkey8)
									, col_name(rkeyid, rkey9)
									, col_name(rkeyid, rkey10)
									, col_name(rkeyid, rkey11)
									, col_name(rkeyid, rkey12)
									, col_name(rkeyid, rkey13)
									, col_name(rkeyid, rkey14)
									, col_name(rkeyid, rkey15))


OPEN cur_fks

FETCH NEXT FROM  cur_fks INTO @sql
WHILE @@FETCH_STATUS = 0 
BEGIN
	exec (@sql)
	FETCH NEXT FROM  cur_fks INTO @sql
END

CLOSE cur_fks
DEALLOCATE cur_fks

-- Pray that nr still isn't looking. Create a cursor of 
-- indexes and statistics, that the field is participating in. 
-- Loop through and drop indexes/stats
DECLARE cur_idx CURSOR FAST_FORWARD READ_ONLY TYPE_WARNING
FOR 
	select distinct i.name, i.status as stat
	from sysindexkeys k with (nolock)
		inner join sysindexes i with (nolock )
		 	on k.id = i.id and k.indid = i.indid 
        where k.id  = object_id('['+@owner+'].['+@table+']')

OPEN cur_idx

FETCH NEXT FROM  cur_idx INTO @idx_name, @stat

WHILE @@FETCH_STATUS = 0 
BEGIN
	IF @stat & 64 = 0   -- Actual index (not statistics)
	BEGIN 
		IF ((@stat & 2048 <>0) OR (@stat & 4096<>0)) --Primary Key or unique key
		BEGIN
			SET @sql = 'ALTER TABLE ['+@owner+'].['+@table+'] DROP CONSTRAINT ['+@idx_name+']'
		END
		ELSE                -- just another index
		BEGIN
			SET @sql = 'DROP INDEX ['+@owner+'].['+@table + '].['+@idx_name +']'
		END
	END 
	ELSE                 -- Statistics
	BEGIN	
		SET @sql = 'DROP STATISTICS ['+@owner+'].['+@table + '].['+@idx_name +']'
	END
	exec (@sql)
	FETCH NEXT FROM  cur_idx INTO @idx_name, @stat

END

CLOSE cur_idx 
DEALLOCATE cur_idx

SET @sql = 'ALTER TABLE ['+@owner+'].['+@table + '] DROP COLUMN [' + @col + ']'

EXEC (@sql)