Condition check for If table exist

[SnehaAgrawal]

How can I use the following Query using Dynamic Sql.The purpose of using Dynamic SQL is the table is on another server.

Generally when I use Dynamic SQL against select query I use
EXEC('SELECT * FROM '+@SERVERNAME+' .'+@LOCALDBNAME +'.DBO.'+'ÇUSTO MERS')

Here goes my Query

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY( id, N'IsUserTable') = 1)
drop table [dbo].[MyTable]
GO

[ck9663]

try:

exec('
if object_id(''' + @database_name + '.owner.tablename'') is not null
  drop table database.owner.tablename'
')

Happy Coding!!!


--- CK