List of tables missing from the query designer in BIDS after the upgrade to 2015.2.2

Version 1

    Details

    No longer able to see the table list in the query designer when working in BIDS after the update to 2015.2.2.


    Resolution

     

    As per our policy we are not showing the table list in the explorer, we have restricted that table list view in the DB security policy. If you still wish to view their DB table list then please use the below SQL query, It will show the list of tables present in their DB.

     

    SQL Query

     

    SELECT * FROM SYS.TABLES ORDER BY NAME

     

    (OR)

     

    SELECT TABLE_NAME

    FROM INFORMATION_SCHEMA.TABLES

    WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME