Table with Keyword name not listed

We have a legacy MSSQL database with a "Status" table. This table does not appear in the list of tables in DataGrip.

Any ideas?

It is in the dbo schema like the other tables.

7 comments
Comment actions Permalink

@Daniel Heard Hi,

Could you specify DataGrip version and MSSQL version?
Do you have permissions to list specified table?
Did you add schema with specified table into intospection scope?
Thank you.

0
Comment actions Permalink

@vasily chernov Hi,

DataGrip version 2017.2.3

MSSQL version 2014 developer (12.0.4100.1)

It is my local dev sql sever which I am connecting to with the sa user. I am able to see the table when I connect with SSMS.

The table is part of the dbo schema. On closer inspection, only 194 tables of the 257 tables are showing in DataGrip. This also seems to only be an issue with this specific database. A similar database is showing all tables including the status table.

Is there a way to get DataGrip to completely refresh the list of tables? I've tried synchronize with no effect.

Thank you!

0
Comment actions Permalink

Hi,
You need to add "dbo" schema into introspection scope:



One can invalidate caches by "Invalidate Caches / Restart ..." action:

Thank you.

0
Comment actions Permalink

Hi,

Thanks for getting back to me.

Caches invalidated with no improvement.

dbo already ticked

Datagrip table list:

SSMS table list:

Thank you

0
Comment actions Permalink

Hi,

Could you attach IDE log?
Thank you.

0
Comment actions Permalink

I can only upload jpegs, gifs and pngs.

0
Comment actions Permalink

@Daniel Heard Hi,

As a workaround you can create public dpaste.com or to create ticket in YouTrack https://youtrack.jetbrains.com/issues/DBE

Thank you.

0

Please sign in to leave a comment.