Supported Schema Objects

Insight recognizes the following types of SQL objects:

UserPreScript - a user-defined script that is executed before any other types are installed
Role - a SQL server user role
Schema - a SQL server schema
UserDefinedType - a user-defined type (e.g. table type)
MasterKey - a database master key
Certificate - a security certificate
SymmetricKey - a security symmetric key
PartitionFunction - a table partitioning function
PartitionScheme - a table partitioning scheme
MessageType - a service broker message type
Contract - a service broker contract
BrokerPriority - a service broker message priority
Queue - a service broker queue
Service - a service broker service
Table
PrimaryKey
Constraint
ForeignKey
Function - a user-defined function
IndexedView - a view with a clustered index. See Indexed Views for details on these.
Index
View
PrimaryXmlIndex - a primary index on an XML column
SecondaryXmlIndex - a secondary index on an XML column
StoredProcedure
Login - a database login
User - a SQL Server user
Permission - a permission on an object
Trigger
Unused - for junk like SET ANSI_PADDING
Script - objects that were scripted by the dependency generator
UserScript - a user-defined script that is executed after all other types are installed

Navigation Menu