Query record in tables..

[mendhak]

IF EXISTS(SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'tablename') AND type = (N'U')) 
BEGIN
   DROP TABLE tablename
END