Table missing in a database but query works

Asked Oct 28 '18 at 11:17

Active Oct 29 '18 at 08:54

Viewed 1,600 times

I have a table TBLT_GLDET in my SQL Server 2008 database. When I open a new query window and select the right database and execute following query

select * 
from TBLT_GLDET;

the data appears. But in the tables list the table does not appear.

Also when I try to open the table for a Crystal Report using database expert in Visual Studio, it says the table is missing in the database.

What is the reason for this?

I did following things. I double checked whether it's the right database. I refreshed the database.

edited Oct 28 '18 at 18:19

asked Oct 28 '18 at 11:17

ChathurawinD

7

maybe there's a `synonym` or `view` with the same name. – Barbaros Özhan Oct 28 '18 at 11:19
2

Maybe you haven't refreshed the object explorer in awhile. I bet `SELECT * FROM sys.objects where [name] = 'TBLT_GLDET';`returns something. (Provided you're connected to the right database). – Thom A Oct 28 '18 at 11:31
You can also use ALT + F1 (after selecting the name) in SSMS to know more about the object and its type. – PSK Oct 28 '18 at 11:54
just refresh your database – Ravi Oct 28 '18 at 15:01

0 Answers0