-- a. modify the type of a column;
-- b. add / remove a column;
-- c. add / remove a DEFAULT constraint;
-- d. add / remove a primary key;
-- e. add / remove a candidate key;
-- f. add / remove a foreign key;
-- g. create / remove a table.


DROP PROC IF EXISTS uspModifyColumnType
GO

CREATE PROC uspModifyColumnType
@table VARCHAR(30),
@column VARCHAR(30),
@desiredDataType VARCHAR(30)
AS
	DECLARE @statement NVARCHAR(4000)
	DECLARE @params NVARCHAR(4000)
	SELECT @statement = 'ALTER TABLE ' + QUOTENAME(@table) + ' ALTER COLUMN ' + QUOTENAME(@column) + QUOTENAME(@desiredDataType)
	SELECT @params = N' @table VARCHAR(30),' +
                     N' @column VARCHAR(30),' +
                     N' @desiredDataType VARCHAR(30)'
	PRINT @statement
	PRINT @params
	EXECUTE sp_executesql @statement, @params, @table = @table, @column = @column, @desiredDataType = @desiredDataType
GO

EXEC uspModifyColumnType 'Products', 'price', 'INT'