CODEWITHSUNDEEP
sqldatabase-administration
user3325655
user3325655

Reputation: 225

Not seeing a table when I expand a database but when I query it returns results

enter image description here

When I run select * from tableTest I am getting 0 rows with column headers. When I expand the database -->Tables I am not seeing this TableTest.

I have sa previleges on this server. Can you help me figure out why this is happening and how can I see tableTest under tables?

Upvotes: 0

Views: 74

Answers (1)

Ed Bangga
Ed Bangga

Reputation: 13006

First to check is what object type is this.

run sp_help 'tableTest'

Upvotes: 1

Related Questions