Rename Column name sql

Method 1:

Syntax:
ALTER TABLE TableName
CHANGE COLUMN OldColumnName NewColumnName Data Type;

Example
ALTER TABLE Test;
CHANGE COLUMN TestingID TestID INT;










Method 2:

Use sp_rename

Syntax :

EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'

find if table exists

SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mONTHLY'
AND TABLE_NAME ='table'

check if stored proc is exists

IF EXISTS (SELECT * FROM dbo.sysobjects 
WHERE id = object_id(N'[dbo].[your_procedure_name]') 
and OBJECTPROPERTY(id, N'IsProcedure') = 1)