Page 1 of 1

SQL Studio - Retrieving Metadata

Posted: Thu 26 Sep 2019 14:37
by mpalmer
When I connect with SQL Studio it retrieves the table names from my database, but not the table metadata. It's not until I add a table to a query that SQL Studio then loads the metadata. So, every time I add a table more metadata is loaded and I have to wait. I've used other competing products that load all metadata upon the initial connection.

How can SQL Studio be configured to load all metadata at once rather than table-by-table?

Thanks!

Re: SQL Studio - Retrieving Metadata

Posted: Thu 26 Sep 2019 18:22
by alexa
You could specify the default database in the 'Database' drop-down menu on the 'General' tab of the Database Connection Properties dialog box (right-click the connection in Database Explorer and select 'Modify Connection...' from the popup menu).

Re: SQL Studio - Retrieving Metadata

Posted: Thu 26 Sep 2019 19:21
by mpalmer
Thanks! That seems to do the trick :)

Re: SQL Studio - Retrieving Metadata

Posted: Mon 30 Sep 2019 12:37
by alexa
Thank you for the reply.

Please let us know if any questions arise.