Table of Contents

Class ObjectSchema.Object

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.objects (Transact-SQL)

Applies to: √ SQL Server √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW) √ SQL analytics endpoint in Microsoft Fabric √ Warehouse in Microsoft Fabric

Contains a row for each user-defined, schema-scoped object that is created within a database, including natively compiled scalar user-defined functions.
For more information, see Scalar User-Defined Functions for In-Memory OLTP.

note


sys.objects doesn't show DDL triggers, because they aren't schema-scoped. All triggers, both DML and DDL, are found in sys.triggers. sys.triggers supports a mixture of name-scoping rules for the various kinds of triggers.


See sys.objects.

[Table(Schema = "sys", Name = "objects", IsView = true)]
public class ObjectSchema.Object
Inheritance
ObjectSchema.Object
Derived
Inherited Members
Extension Methods

Properties

AssemblyModule

assembly_modules (sys.assembly_modules)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.AssemblyModule? AssemblyModule { get; set; }

Property Value

ObjectSchema.AssemblyModule

ChangeTrackingTables

change_tracking_tables (sys.change_tracking_tables)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ChangeTrackingSchema.ChangeTrackingTable> ChangeTrackingTables { get; set; }

Property Value

IList<ChangeTrackingSchema.ChangeTrackingTable>

CheckConstraint

check_constraints (sys.check_constraints)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.CheckConstraint? CheckConstraint { get; set; }

Property Value

ObjectSchema.CheckConstraint

ColumnStoreRowGroups

column_store_row_groups (sys.column_store_row_groups)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ColumnStoreRowGroup> ColumnStoreRowGroups { get; set; }

Property Value

IList<ObjectSchema.ColumnStoreRowGroup>

ColumnTypeUsages

column_type_usages (sys.column_type_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ScalarTypesSchema.ColumnTypeUsage> ColumnTypeUsages { get; set; }

Property Value

IList<ScalarTypesSchema.ColumnTypeUsage>

ColumnXmlSchemaCollectionUsages

column_xml_schema_collection_usages (sys.column_xml_schema_collection_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<XmlSchema.ColumnXmlSchemaCollectionUsage> ColumnXmlSchemaCollectionUsages { get; set; }

Property Value

IList<XmlSchema.ColumnXmlSchemaCollectionUsage>

Columns

columns (sys.columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Column> Columns { get; set; }

Property Value

IList<ObjectSchema.Column>

ComputedColumns

computed_columns (sys.computed_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ComputedColumn> ComputedColumns { get; set; }

Property Value

IList<ObjectSchema.ComputedColumn>

CreateDate

create_date NOT NULL datetime

Date the object was created. 
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

DatabaseEventSessionFields

database_event_session_fields (sys.database_event_session_fields)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ExtendedEventsSchema.DatabaseEventSessionField> DatabaseEventSessionFields { get; set; }

Property Value

IList<ExtendedEventsSchema.DatabaseEventSessionField>

DefaultConstraint

default_constraints (sys.default_constraints)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.DefaultConstraint? DefaultConstraint { get; set; }

Property Value

ObjectSchema.DefaultConstraint

EventNotifications

event_notifications (sys.event_notifications)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.EventNotification> EventNotifications { get; set; }

Property Value

IList<ObjectSchema.EventNotification>

Events

events (sys.events)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Event> Events { get; set; }

Property Value

IList<ObjectSchema.Event>

ExternalTables

external_tables (sys.external_tables)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ExternalOperationsSchema.ExternalTable> ExternalTables { get; set; }

Property Value

IList<ExternalOperationsSchema.ExternalTable>

FiletableSystemDefinedObjects

filetable_system_defined_objects (sys.filetable_system_defined_objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FilestreamAndFileTableSchema.FileTableSystemDefinedObject> FiletableSystemDefinedObjects { get; set; }

Property Value

IList<FilestreamAndFileTableSchema.FileTableSystemDefinedObject>

Filetables

filetables (sys.filetables)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FilestreamAndFileTableSchema.FileTable> Filetables { get; set; }

Property Value

IList<FilestreamAndFileTableSchema.FileTable>

ForeignKey

foreign_keys (sys.foreign_keys)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.ForeignKey? ForeignKey { get; set; }

Property Value

ObjectSchema.ForeignKey

FulltextIndexCatalogUsages

fulltext_index_catalog_usages (sys.fulltext_index_catalog_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FullTextSearchSchema.IndexCatalogUsage> FulltextIndexCatalogUsages { get; set; }

Property Value

IList<FullTextSearchSchema.IndexCatalogUsage>

FulltextIndexColumns

fulltext_index_columns (sys.fulltext_index_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FullTextSearchSchema.IndexColumn> FulltextIndexColumns { get; set; }

Property Value

IList<FullTextSearchSchema.IndexColumn>

FulltextIndexes

fulltext_indexes (sys.fulltext_indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FullTextSearchSchema.Index> FulltextIndexes { get; set; }

Property Value

IList<FullTextSearchSchema.Index>

FunctionOrderColumns

function_order_columns (sys.function_order_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.FunctionOrderColumn> FunctionOrderColumns { get; set; }

Property Value

IList<ObjectSchema.FunctionOrderColumn>

HashIndexes

hash_indexes (sys.hash_indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.HashIndex> HashIndexes { get; set; }

Property Value

IList<ObjectSchema.HashIndex>

IdentityColumns

identity_columns (sys.identity_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IdentityColumn> IdentityColumns { get; set; }

Property Value

IList<ObjectSchema.IdentityColumn>

IndexColumns

index_columns (sys.index_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IndexColumn> IndexColumns { get; set; }

Property Value

IList<ObjectSchema.IndexColumn>

IndexResumableOperations

index_resumable_operations (sys.index_resumable_operations)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IndexResumableOperation> IndexResumableOperations { get; set; }

Property Value

IList<ObjectSchema.IndexResumableOperation>

Indexes

indexes (sys.indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Index> Indexes { get; set; }

Property Value

IList<ObjectSchema.Index>

InternalPartitions

internal_partitions (sys.internal_partitions)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.InternalPartition> InternalPartitions { get; set; }

Property Value

IList<ObjectSchema.InternalPartition>

InternalTables

internal_tables (sys.internal_tables)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.InternalTable> InternalTables { get; set; }

Property Value

IList<ObjectSchema.InternalTable>

IsMSShipped

is_ms_shipped NOT NULL bit

Object is created by an internal SQL Server component. 
[Column("is_ms_shipped")]
[NotNull]
public bool IsMSShipped { get; set; }

Property Value

bool

IsPublished

is_published NOT NULL bit

Object is published. 
[Column("is_published")]
[NotNull]
public bool IsPublished { get; set; }

Property Value

bool

IsSchemaPublished

is_schema_published NOT NULL bit

Only the schema of the object is published. 
[Column("is_schema_published")]
[NotNull]
public bool IsSchemaPublished { get; set; }

Property Value

bool

KeyConstraint

key_constraints (sys.key_constraints)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.KeyConstraint? KeyConstraint { get; set; }

Property Value

ObjectSchema.KeyConstraint

LedgerColumnHistory

ledger_column_history (sys.ledger_column_history)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.LedgerColumnHistory> LedgerColumnHistory { get; set; }

Property Value

IList<SecuritySchema.LedgerColumnHistory>

LedgerTableHistory

ledger_table_history (sys.ledger_table_history)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.LedgerTableHistory> LedgerTableHistory { get; set; }

Property Value

IList<SecuritySchema.LedgerTableHistory>

MaskedColumns

masked_columns (sys.masked_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.MaskedColumn> MaskedColumns { get; set; }

Property Value

IList<ObjectSchema.MaskedColumn>

MemoryOptimizedTablesInternalAttributes

memory_optimized_tables_internal_attributes (sys.memory_optimized_tables_internal_attributes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.MemoryOptimizedTablesInternalAttribute> MemoryOptimizedTablesInternalAttributes { get; set; }

Property Value

IList<ObjectSchema.MemoryOptimizedTablesInternalAttribute>

ModifyDate

modify_date NOT NULL datetime

Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when an index on the table or view is created or altered. 
[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

ModuleAssemblyUsages

module_assembly_usages (sys.module_assembly_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ModuleAssemblyUsage> ModuleAssemblyUsages { get; set; }

Property Value

IList<ObjectSchema.ModuleAssemblyUsage>

Name

name NOT NULL sysname

Object name. 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

NumberedProcedureParameters

numbered_procedure_parameters (sys.numbered_procedure_parameters)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.NumberedProcedureParameter> NumberedProcedureParameters { get; set; }

Property Value

IList<ObjectSchema.NumberedProcedureParameter>

NumberedProcedures

numbered_procedures (sys.numbered_procedures)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.NumberedProcedure> NumberedProcedures { get; set; }

Property Value

IList<ObjectSchema.NumberedProcedure>

ObjectID

object_id NOT NULL int

Object identification number. Is unique within a database. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParameterTypeUsages

parameter_type_usages (sys.parameter_type_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ScalarTypesSchema.ParameterTypeUsage> ParameterTypeUsages { get; set; }

Property Value

IList<ScalarTypesSchema.ParameterTypeUsage>

ParameterXmlSchemaCollectionUsages

parameter_xml_schema_collection_usages (sys.parameter_xml_schema_collection_usages)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<XmlSchema.ParameterXmlSchemaCollectionUsage> ParameterXmlSchemaCollectionUsages { get; set; }

Property Value

IList<XmlSchema.ParameterXmlSchemaCollectionUsage>

Parameters

parameters (sys.parameters)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Parameter> Parameters { get; set; }

Property Value

IList<ObjectSchema.Parameter>

ParentObjectID

parent_object_id NOT NULL int

ID of the object to which this object belongs.

0 = Not a child object. 
[Column("parent_object_id")]
[NotNull]
public int ParentObjectID { get; set; }

Property Value

int

Partitions

partitions (sys.partitions)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Partition> Partitions { get; set; }

Property Value

IList<ObjectSchema.Partition>

PdwColumnDistributionProperties

pdw_column_distribution_properties (sys.pdw_column_distribution_properties)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.ColumnDistributionProperty> PdwColumnDistributionProperties { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.ColumnDistributionProperty>

PdwIndexMappings

pdw_index_mappings (sys.pdw_index_mappings)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.IndexMapping> PdwIndexMappings { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.IndexMapping>

PdwMaterializedViewColumnDistributionProperties

pdw_materialized_view_column_distribution_properties (sys.pdw_materialized_view_column_distribution_properties)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty> PdwMaterializedViewColumnDistributionProperties { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty>

PdwMaterializedViewDistributionProperties

pdw_materialized_view_distribution_properties (sys.pdw_materialized_view_distribution_properties)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.MaterializedViewDistributionProperty> PdwMaterializedViewDistributionProperties { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.MaterializedViewDistributionProperty>

PdwMaterializedViewMappings

pdw_materialized_view_mappings (sys.pdw_materialized_view_mappings)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.MaterializedViewMapping> PdwMaterializedViewMappings { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.MaterializedViewMapping>

PdwNodesColumnStoreRowGroups

pdw_nodes_column_store_row_groups (sys.pdw_nodes_column_store_row_groups)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesColumnStoreRowGroup> PdwNodesColumnStoreRowGroups { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.NodesColumnStoreRowGroup>

PdwNodesColumns

pdw_nodes_columns (sys.pdw_nodes_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesColumn> PdwNodesColumns { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.NodesColumn>

PdwNodesIndexes

pdw_nodes_indexes (sys.pdw_nodes_indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesIndex> PdwNodesIndexes { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.NodesIndex>

PdwNodesPartitions

pdw_nodes_partitions (sys.pdw_nodes_partitions)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesPartition> PdwNodesPartitions { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.NodesPartition>

PdwNodesTables

pdw_nodes_tables (sys.pdw_nodes_tables)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesTable> PdwNodesTables { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.NodesTable>

PdwPermanentTableMappings

pdw_permanent_table_mappings (sys.pdw_permanent_table_mappings)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.PermanentTableMapping> PdwPermanentTableMappings { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.PermanentTableMapping>

PdwReplicatedTableCacheState

pdw_replicated_table_cache_state (sys.pdw_replicated_table_cache_state)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.ReplicatedTableCacheState> PdwReplicatedTableCacheState { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.ReplicatedTableCacheState>

PdwTableDistributionProperties

pdw_table_distribution_properties (sys.pdw_table_distribution_properties)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.TableDistributionProperty> PdwTableDistributionProperties { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.TableDistributionProperty>

PdwTableMappings

pdw_table_mappings (sys.pdw_table_mappings)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.TableMapping> PdwTableMappings { get; set; }

Property Value

IList<AzureSynapseAnalyticsSchema.TableMapping>

Periods

periods (sys.periods)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Period> Periods { get; set; }

Property Value

IList<ObjectSchema.Period>

PrincipalID

principal_id NULL int

ID of the individual owner, if different from the schema owner. By default, schema-contained objects are owned by the schema owner. However, an alternate owner can be specified by using the ALTER AUTHORIZATION statement to change ownership.

NULL if there's no alternate individual owner.

Is NULL if the object type is one of the following values:

C = Check constraint
D = Default (constraint or stand-alone)
F = Foreign key constraint
PK = Primary key constraint
R = Rule (old-style, stand-alone)
TA = Assembly (CLR-integration) trigger
TR = SQL trigger
UQ = Unique constraint
EC = Edge constraint 
[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

Procedures

procedures (sys.procedures)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Procedure> Procedures { get; set; }

Property Value

IList<ObjectSchema.Procedure>

QueryStoreQuery

query_store_query (sys.query_store_query)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<QueryStoreSchema.QueryStoreQuery> QueryStoreQuery { get; set; }

Property Value

IList<QueryStoreSchema.QueryStoreQuery>

SchemaID

schema_id NOT NULL int

ID of the schema that the object is contained in.

Schema-scoped system objects are always contained in the sys or INFORMATION_SCHEMA schemas. 
[Column("schema_id")]
[NotNull]
public int SchemaID { get; set; }

Property Value

int

SecurityPolicies

security_policies (sys.security_policies)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.SecurityPolicy> SecurityPolicies { get; set; }

Property Value

IList<SecuritySchema.SecurityPolicy>

SecurityPredicates

security_predicates (sys.security_predicates)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.SecurityPredicate> SecurityPredicates { get; set; }

Property Value

IList<SecuritySchema.SecurityPredicate>

SelectiveXmlIndexPaths

selective_xml_index_paths (sys.selective_xml_index_paths)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<XmlSchema.SelectiveXmlIndexPath> SelectiveXmlIndexPaths { get; set; }

Property Value

IList<XmlSchema.SelectiveXmlIndexPath>

Sequences

sequences (sys.sequences)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Sequence> Sequences { get; set; }

Property Value

IList<ObjectSchema.Sequence>

ServerAssemblyModules

server_assembly_modules (sys.server_assembly_modules)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerAssemblyModule> ServerAssemblyModules { get; set; }

Property Value

IList<ObjectSchema.ServerAssemblyModule>

ServerEventNotifications

server_event_notifications (sys.server_event_notifications)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerEventNotification> ServerEventNotifications { get; set; }

Property Value

IList<ObjectSchema.ServerEventNotification>

ServerEventSessionFields

server_event_session_fields (sys.server_event_session_fields)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ExtendedEventsSchema.ServerEventSessionField> ServerEventSessionFields { get; set; }

Property Value

IList<ExtendedEventsSchema.ServerEventSessionField>

ServerEvents

server_events (sys.server_events)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerEvent> ServerEvents { get; set; }

Property Value

IList<ObjectSchema.ServerEvent>

ServerSqlModules

server_sql_modules (sys.server_sql_modules)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerSqlModule> ServerSqlModules { get; set; }

Property Value

IList<ObjectSchema.ServerSqlModule>

ServerTriggers

server_triggers (sys.server_triggers)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerTrigger> ServerTriggers { get; set; }

Property Value

IList<ObjectSchema.ServerTrigger>

ServiceQueue

service_queues (sys.service_queues)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ServiceBrokerSchema.ServiceQueue? ServiceQueue { get; set; }

Property Value

ServiceBrokerSchema.ServiceQueue

SpatialIndexTessellations

spatial_index_tessellations (sys.spatial_index_tessellations)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SpatialDataSchema.SpatialIndexTessellation> SpatialIndexTessellations { get; set; }

Property Value

IList<SpatialDataSchema.SpatialIndexTessellation>

SpatialIndexes

spatial_indexes (sys.spatial_indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SpatialDataSchema.SpatialIndex> SpatialIndexes { get; set; }

Property Value

IList<SpatialDataSchema.SpatialIndex>

SqlDependencies

sql_dependencies (sys.sql_dependencies)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.SqlDependency> SqlDependencies { get; set; }

Property Value

IList<ObjectSchema.SqlDependency>

SqlModules

sql_modules (sys.sql_modules)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.SqlModule> SqlModules { get; set; }

Property Value

IList<ObjectSchema.SqlModule>

Stats

stats (sys.stats)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Stat> Stats { get; set; }

Property Value

IList<ObjectSchema.Stat>

StatsColumns

stats_columns (sys.stats_columns)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.StatsColumn> StatsColumns { get; set; }

Property Value

IList<ObjectSchema.StatsColumn>

Synonym

synonyms (sys.synonyms)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.Synonym? Synonym { get; set; }

Property Value

ObjectSchema.Synonym

TriggerEvents

trigger_events (sys.trigger_events)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.TriggerEvent> TriggerEvents { get; set; }

Property Value

IList<ObjectSchema.TriggerEvent>

Triggers

triggers (sys.triggers)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Trigger> Triggers { get; set; }

Property Value

IList<ObjectSchema.Trigger>

Type

type NULL char(2)

Object type:

AF = Aggregate function (CLR)
C = Check constraint
D = Default (constraint or stand-alone)
F = Foreign key constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function (TVF)
IT = Internal table
P = SQL stored procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = Primary key constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SO = Sequence object
U = Table (user-defined)
V = View

Applies to: SQL Server 2012 (11.x) and later versions

SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function (TVF)
TR = SQL DML trigger
TT = Table type
UQ = unique constraint
X = Extended stored procedure

Applies to: SQL Server 2014 (12.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

ST = Statistics tree

Applies to: SQL Server 2016 (13.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

ET = External table

Applies to: SQL Server 2017 (14.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

EC = Edge constraint 
[Column("type")]
[Nullable]
public string? Type { get; set; }

Property Value

string

TypeDesc

type_desc NULL nvarchar(60)

Description of the object type:

AGGREGATE_FUNCTION
CHECK_CONSTRAINT
CLR_SCALAR_FUNCTION
CLR_STORED_PROCEDURE
CLR_TABLE_VALUED_FUNCTION
CLR_TRIGGER
DEFAULT_CONSTRAINT
EDGE_CONSTRAINT
EXTENDED_STORED_PROCEDURE
FOREIGN_KEY_CONSTRAINT
INTERNAL_TABLE
PLAN_GUIDE
PRIMARY_KEY_CONSTRAINT
REPLICATION_FILTER_PROCEDURE
RULE
SEQUENCE_OBJECT
SERVICE_QUEUE
SQL_INLINE_TABLE_VALUED_FUNCTION
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
SYNONYM
SYSTEM_TABLE
TYPE_TABLE
UNIQUE_CONSTRAINT
USER_TABLE
VIEW 
[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string

View

views (sys.views)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.View? View { get; set; }

Property Value

ObjectSchema.View

XmlIndexes

xml_indexes (sys.xml_indexes)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<XmlSchema.XmlIndex> XmlIndexes { get; set; }

Property Value

IList<XmlSchema.XmlIndex>