How To Execute Alter Statement within IF Exists block in SQL server

To execute DML statement within IF block we need to use command named "EXEC"..

 

E.g.

 

IF EXISTS(SELECT * from SYSOBJECTS WHERE name LIKE 'XXXXXX')

BEGIN

   EXEC(' ALTER TABLE XYZ ............')

END