Types Supported in the Prompt List of dbForge SQL Complete

In this topic, types supported in the prompt list of dbForge SQL Complete are described:

Database  Databases

Linked Server  Linked Servers

Schema  Schemas

Table  Tables

View  Views

 Encrypted Views

Column  Columns of table objects

Stored Function  Scalar functions (including CLR), CLR aggregate functions

Table-Valued Function  Table-valued (including CLR) functions

Built-in function  Built-in functions

Table Level Trigger  Table level trigger

Encrypted Table Level Trigger  Encrypted table level trigger

Database Level Trigger  Database level trigger

Encrypted Database Level Trigger  Encrypted database level trigger

 Server Level Trigger  Server level trigger

 Encrypted Server Level Trigger  Encrypted server level trigger

Synonym  Synonyms for supported objects

XMLSchemaCollection  XML Schema Collection

Alias  Aliases for table objects (table, view, stored procedure, function, synonym, sub-query)

JOIN  Suggested conditions for JOIN statements 

Keyword  Suggested keywords

Built-in data type  Built-in data types

User data type  User data types

@@ built-in function  Built-in functions starting with @@

Variable  Local and cursor variables

Function parameter  Function and procedure in parameters

Out parameter  Out parameters for procedures

Collation  Collations

Cursor  Cursors

Label  Labels

Language  Languages

 Snippets

 Procedures

 Users

 Roles

See Also