From SSMS 2008 onwards, we have the IntelliSense feature.It provides internal metadata and a list of available objects and properties while writing T-SQL queries.
The below are the steps to follow for the same
Step 1: Go to Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense and make sure the Enable IntelliSense checkbox is checked
Step 2: To verify that it is enabled, go to the Query menu and check that IntelliSense is enabled. Alternatively, the short cut key for the same is Ctrl+Q, Ctrl+I
Alternatively, if your are looking for some 3rd party effective tool, you can try with
a) dbForge SQL Complete (https://www.devart.com/dbforge/sql/sqlcomplete/
) . A free edition is also available.
b) The SQL Developer Suite from RedGate(http://www.red-gate.com/products/sql-development/sql-developer-suite/
). A 14days trial version is available.
Hope this helpsAmatya, if this helps please login to Mark As Answer. | Alert Moderator