Return
-
Title
How to filter out database objects in the intellisense, dot-look-up, or autofill pop up. -
Description
User types in the Editor window a query or statement then presses "." or dot and a window appears to assist in inserting the database object name. For example,
select * from dbo.
will open a list of all objects belonging to dbo. However there is no way to filter out objects you're not interested in. For example user wants to only list tables because stored procedures would not make sense in this type of SQL query.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.