Object information
It is impossible to keep in mind every column name and data type. In SSMS, it is necessary to navigate in the Object Explorer to the object (e.g. a table) and generate a script - or click the table and go to the column list. This is where SQL Complete can come in handy, allowing users to view extra information quickly and easily.
Quick object overview
The Quick object overview window automatically appears when the mouse hovers over any existing object, allowing viewing its object information in a tooltip.
The quick overview provides the following information: the name of the schema a table belongs to, column data types and constraints, indexes, primary and unique keys, foreign keys, additional column properties (e.g., not null and identify attributes), as well as estimate row count. SQL Complete also displays the quick information for the asterisk (a shorthand for all the columns) in a tooltip.
Getting quick information can be helpful in a number of cases. For instance, if you are writing a query with a WHERE clause that filters out data from a certain column, you can check the index information on that column and see whether your query will run fast.
In some cases, the Quick object overview window might cover up the code you want to see. You can make the suggestions semi-transparent for as long as you need by pressing and holding the Ctrl key.
When it comes to a column, the information provided by the Quick object overview window is as follows: the related table, type of data and nullability, as well as the Extended Properties for this column.
Note
A green + icon means that the object has been created in the script, not in the database.
A shield icon at the column means that it contains added metadata about the sensitivity classification:
- Red color is for sensitivity columns of a table with the critical rank
- Yellow color is for sensitivity columns of a table with the high rank
- Blue color implies sensitivity columns of a table with the medium rank
- Green color is for sensitivity columns of a table with the low rank
- Black color implies sensitivity columns of a table without any rank
Parameter information
The Parameter information tooltip automatically appears upon opening a round bracket for a function or after a procedure name.
The active parameter will be displayed in bold.
This is what it looks like for a procedure:
The description of the parameter will be displayed if it was described during the creation of the procedure by means of extended properties.
This is what it looks like for a function:
The arrows denote function overloading. In this case, the function may have two or three parameters.
Column information in values
The Column information tooltip automatically appears upon opening a round bracket for values in the INSERT statement. The active value is taken in bold.
Supported objects
 |
Aliases for table objects (tables, views, functions, synonyms, sub-queries) |
 |
Built-in data types |
 |
Built-in functions |
 |
Check constraints |
 |
Collations |
  |
Column master keys (described from a database or a script respectively) |
 |
Columns classified with the critical sensitivity rank |
 |
Columns classified with the high sensitivity rank |
 |
Columns classified with the medium sensitivity rank |
 |
Columns classified with the low sensitivity rank |
 |
Columns without any sensitivity rank assigned |
  |
Columns of table objects (described from a database or a script respectively) |
  |
Columns with a primary key (described from a database or a script respectively) |
  |
Columns with a unique key (described from a database or a script respectively) |
 |
Columns with primary and foreign keys |
  |
Contracts (described from a database or a script respectively) |
 |
Cursors |
  |
Database-level triggers (described from a database or a script respectively) |
  |
Databases (described from a server or a script respectively) |
 |
Default constraints |
 |
Defaults |
 |
Encrypted database-level triggers |
 |
Encrypted scalar functions |
 |
Encrypted server-level triggers |
 |
Encrypted table-level triggers |
 |
Encrypted table-valued (including CLR) functions |
 |
Encrypted views |
 |
Filegroups |
 |
Foreign keys |
 |
Full text stop lists |
 |
Global system variables |
  |
IN parameters for procedures and functions (described from a database or a script respectively) |
 |
Indexes |
 |
Labels |
 |
Languages |
 |
Linked servers |
 |
Local variables |
 |
Logins |
 |
Message types |
  |
OUT parameters for procedures and functions (described from a database or a script respectively) |
 |
Primary keys |
  |
Procedures (described from a database or a script respectively) |
  |
Queues (described from a database or a script respectively) |
 |
Roles |
  |
Routes (described from a database or a script respectively) |
  |
Rules (described from a database or a script respectively) |
  |
Scalar functions (described from a database or a script respectively) |
 |
Schemas |
  |
Sequences (described from a database or a script respectively) |
  |
Server-level triggers (described from a server or a script respectively) |
 |
Servers |
  |
Services (described from a database or a script respectively) |
 |
Snippets |
 |
Suggested conditions after the ON keyword |
 |
Suggested conditions for JOIN statements |
 |
Suggested keywords |
  |
Synonyms for supported objects (described from a database or a script respectively) |
  |
Table-level triggers (described from a database or a script respectively) |
  |
Table-valued (including CLR) functions (described from a database or a script respectively) |
  |
Tables (described from a database or a script respectively) |
 |
Transactions |
  |
User-defined data types (described from a database or a script respectively) |
  |
User-defined table types (described from a database or a script respectively) |
 |
User-defined types |
 |
Users |
  |
Views (described from a database or a script respectively) |
 |
XML indexes |
 |
XML Schema Collections |
Want to Find out More?
Overview
All features
Request a demo
