>How can i test if a field exist in SQL SERVER Table and then rename it and change de field with, programaticaly.

IF EXISTS(SELECT * FROM MyDB.INFORMATION_SCHEMA.COLUMNS
		WHERE table_name = 'MyTable' 
			and column_name = 'MyColumnName')
  EXECUTE sp_rename N'dbo.MyDB.MyColumnName', N'NewColumnName', 'COLUMN'