Drop Table error

Question

Hi,

The following one is producing error;  Please let me know how to drop the table which set in variable @A;

DECLARE @A VARCHAR(40);
SET @A='MyTable';
IF OBJECT_ID(@A) IS NOT NULL
DROP TABLE @A;

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '@A'.

Answer 1

Thanks got it while google;

DECLARE @A VARCHAR(40);
SET @A='MyTable';
IF OBJECT_ID(@A) IS NOT NULL
Execute ('DROP TABLE '+@A);