4 comments

Add a comment…

Sign in

prestine

Your email address

Check!

invalid email

(thinking…)

Reset

or sign in with

• 
• 

UserVoice password

Forgot password?

Create a password

Your name

I agree to the terms of service

You'll receive a confirmation email with a link to create a password (optional).

Signed in as (Sign out)

Close

Close

Post comment Submitting...

• AdminEdgar Sherman (Admin, advantage) commented  ·  Dec 04, 2009 8:08 am  ·  Flag as inappropriate  ·  Delete

  @AzzaAzza69
  It works on free tables. Two gotchas with sp_gettables. 1) The tableNamePattern is case sensitive. 2) don't add the # when looking for temp tables (see KB Item 091124-2232 for a more complete explanation)

• AzzaAzza69 commented  ·  Dec 03, 2009 12:12 am  ·  Flag as inappropriate  ·  Delete

  Neither of the above methods (sp_GetTables or SELECT...from system.tables) work for the non-data dictionary connection method!

• AdminEdgar Sherman (Admin, advantage) commented  ·  Aug 24, 2009 9:09 am  ·  Flag as inappropriate  ·  Delete

  This should work already. At least it works for me in 9.1. One possible gotcha would be temp tables as they are not added to system.tables. In this case you can use sp_GetTables stored procedure.

• synack commented  ·  Aug 20, 2009 9:10 am  ·  Flag as inappropriate  ·  Delete

  if exists (select name from system.tables where name ='test') then
  drop table test;
  end if;