sql server - Reader not returning rows on check of Table Existance -

sql server - Reader not returning rows on check of Table Existance -

i know sure table exists yet reader has no rows. expect name of table come if exists

using (var cmd = new sqlcommand("select name sys.objects object_id = object_id(n'" + tablename + "') , type in (n'u')", sqlconnection)) { var reader = cmd.executereader(); { using (reader) { if (!reader.hasrows) homecoming false; while (reader.read()) tablenamefound = reader.getstring(0); } } }

i ran query straight in management studio , "cars":

select name sys.objects object_id = object_id(n'cars') , type in (n'u')

so maybe shouldn't using reader here? don't know.

your query fine.

check:

if run on right database / schema. query fail when running in master illustration when table in database / schema; if parameter come in doesn't contain spaces, etc.

sql-server tsql