vs.vaidyanathan 18 Newbie Poster

if not exists
(select * from sysobjects where name='amrreconAccountsTB')
begin
execute "create amrreconAccountsTB(acct_id char(2048) NULL)"
end;
Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2):
error near the keyword 'end'.
Can someone please help me and tell me what is the syntax error here?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.