SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Haris Ahmad / Drop a table and views / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:46:02 GMT20RE: Drop a table and viewshttp://www.sqlservercentral.com/Forums/Topic512386-1310-1.aspxsave yerself some typing:if object_id('dbo.table_name') is not null drop dbo.table_nametoss that at the top of the script too before dropping the sp ahead of the create statementWed, 23 Jul 2008 07:03:24 GMTRobert SeligaDrop a table and viewshttp://www.sqlservercentral.com/Forums/Topic512386-1310-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Dropping+table/63344/">Drop a table and views</A>[/B]Thu, 05 Jun 2008 12:25:08 GMTahmadharis