I have this table as below and I want to remove the last column (DESCRIPTION_EXTENDED). It is used in newer version of app but I want to keep the orig. as it was. What is the process to remove this column? I understand to use ALTER and DROP but do I have to something else?
SELECT TOP 1000 [ID] ,[FACILITY_KEY] ,[FIRST_LEVEL_CAT] ,[SECOND_LEVEL_CAT] ,[UNIQUE_KEY] ,[DESCRIPTION] ,[ACTIVE] ,[ORIG_ID] ,[COLOR] ,[PARENT_ID] ,[ADDRESS] ,[PHONE] ,[COMMENTS] ,[DESCRIPTION_EXTENDED] FROM [DPRO2].[OGEN].[SCH_C_RESOURCES]