Class ObjectSchema.Object
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.objects (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each user-defined, schema-scoped object that is created within a database, including natively compiled scalar user-defined function.
For more information, see Scalar User-Defined Functions for In-Memory OLTP.
note
sys.objects does not show DDL triggers, because they are not 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
- Extension Methods
Properties
AssemblyModule
assembly_modules (sys.assembly_modules)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.AssemblyModule? AssemblyModule { get; set; }Property Value
ChangeTrackingTables
change_tracking_tables (sys.change_tracking_tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ChangeTrackingSchema.ChangeTrackingTable> ChangeTrackingTables { get; set; }Property Value
CheckConstraint
check_constraints (sys.check_constraints)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.CheckConstraint? CheckConstraint { get; set; }Property Value
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
ColumnTypeUsages
column_type_usages (sys.column_type_usages)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ScalarTypesSchema.ColumnTypeUsage> ColumnTypeUsages { get; set; }Property Value
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
Columns
columns (sys.columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Column> Columns { get; set; }Property Value
ComputedColumns
computed_columns (sys.computed_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ComputedColumn> ComputedColumns { get; set; }Property Value
CreateDate
Date the object was created.
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }Property Value
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
DefaultConstraint
default_constraints (sys.default_constraints)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.DefaultConstraint? DefaultConstraint { get; set; }Property Value
EventNotifications
event_notifications (sys.event_notifications)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.EventNotification> EventNotifications { get; set; }Property Value
Events
events (sys.events)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Event> Events { get; set; }Property Value
ExtendedProcedures
extended_procedures (sys.extended_procedures)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ExtendedProcedure> ExtendedProcedures { get; set; }Property Value
ExternalTables
external_tables (sys.external_tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ExternalOperationsSchema.ExternalTable> ExternalTables { get; set; }Property Value
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
Filetables
filetables (sys.filetables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FilestreamAndFileTableSchema.FileTable> Filetables { get; set; }Property Value
ForeignKey
foreign_keys (sys.foreign_keys)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.ForeignKey? ForeignKey { get; set; }Property Value
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
FulltextIndexColumns
fulltext_index_columns (sys.fulltext_index_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FullTextSearchSchema.IndexColumn> FulltextIndexColumns { get; set; }Property Value
FulltextIndexes
fulltext_indexes (sys.fulltext_indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<FullTextSearchSchema.Index> FulltextIndexes { get; set; }Property Value
FunctionOrderColumns
function_order_columns (sys.function_order_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.FunctionOrderColumn> FunctionOrderColumns { get; set; }Property Value
HashIndexes
hash_indexes (sys.hash_indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.HashIndex> HashIndexes { get; set; }Property Value
IdentityColumns
identity_columns (sys.identity_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IdentityColumn> IdentityColumns { get; set; }Property Value
IndexColumns
index_columns (sys.index_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IndexColumn> IndexColumns { get; set; }Property Value
IndexResumableOperations
index_resumable_operations (sys.index_resumable_operations)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.IndexResumableOperation> IndexResumableOperations { get; set; }Property Value
Indexes
indexes (sys.indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Index> Indexes { get; set; }Property Value
InternalPartitions
internal_partitions (sys.internal_partitions)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.InternalPartition> InternalPartitions { get; set; }Property Value
InternalTables
internal_tables (sys.internal_tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.InternalTable> InternalTables { get; set; }Property Value
IsMSShipped
Object is created by an internal SQL Server component.
[Column("is_ms_shipped")]
[NotNull]
public bool IsMSShipped { get; set; }Property Value
IsPublished
Object is published.
[Column("is_published")]
[NotNull]
public bool IsPublished { get; set; }Property Value
IsSchemaPublished
Only the schema of the object is published.
[Column("is_schema_published")]
[NotNull]
public bool IsSchemaPublished { get; set; }Property Value
KeyConstraint
key_constraints (sys.key_constraints)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.KeyConstraint? KeyConstraint { get; set; }Property Value
LedgerColumnHistory
ledger_column_history (sys.ledger_column_history)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.LedgerColumnHistory> LedgerColumnHistory { get; set; }Property Value
LedgerTableHistory
ledger_table_history (sys.ledger_table_history)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.LedgerTableHistory> LedgerTableHistory { get; set; }Property Value
MaskedColumns
masked_columns (sys.masked_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.MaskedColumn> MaskedColumns { get; set; }Property Value
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
ModifyDate
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
ModuleAssemblyUsages
module_assembly_usages (sys.module_assembly_usages)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ModuleAssemblyUsage> ModuleAssemblyUsages { get; set; }Property Value
Name
Object name.
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
NumberedProcedureParameters
numbered_procedure_parameters (sys.numbered_procedure_parameters)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.NumberedProcedureParameter> NumberedProcedureParameters { get; set; }Property Value
NumberedProcedures
numbered_procedures (sys.numbered_procedures)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.NumberedProcedure> NumberedProcedures { get; set; }Property Value
ObjectID
Object identification number. Is unique within a database.
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }Property Value
ParameterTypeUsages
parameter_type_usages (sys.parameter_type_usages)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ScalarTypesSchema.ParameterTypeUsage> ParameterTypeUsages { get; set; }Property Value
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
Parameters
parameters (sys.parameters)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Parameter> Parameters { get; set; }Property Value
ParentObjectID
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
Partitions
partitions (sys.partitions)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Partition> Partitions { get; set; }Property Value
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
PdwIndexMappings
pdw_index_mappings (sys.pdw_index_mappings)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.IndexMapping> PdwIndexMappings { get; set; }Property Value
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
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
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
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
PdwNodesColumns
pdw_nodes_columns (sys.pdw_nodes_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesColumn> PdwNodesColumns { get; set; }Property Value
PdwNodesIndexes
pdw_nodes_indexes (sys.pdw_nodes_indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesIndex> PdwNodesIndexes { get; set; }Property Value
PdwNodesPartitions
pdw_nodes_partitions (sys.pdw_nodes_partitions)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesPartition> PdwNodesPartitions { get; set; }Property Value
PdwNodesTables
pdw_nodes_tables (sys.pdw_nodes_tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.NodesTable> PdwNodesTables { get; set; }Property Value
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
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
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
PdwTableMappings
pdw_table_mappings (sys.pdw_table_mappings)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<AzureSynapseAnalyticsSchema.TableMapping> PdwTableMappings { get; set; }Property Value
Periods
periods (sys.periods)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Period> Periods { get; set; }Property Value
PrincipalID
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.
Is NULL if there is no alternate individual owner.
Is NULL if the object type is one of the following:
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
QueryStoreQuery
query_store_query (sys.query_store_query)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<QueryStoreSchema.QueryStoreQuery> QueryStoreQuery { get; set; }Property Value
RemoteDataArchiveTables
remote_data_archive_tables (sys.remote_data_archive_tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<StretchDatabaseSchema.RemoteDataArchiveTable> RemoteDataArchiveTables { get; set; }Property Value
SchemaID
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
SecurityPolicies
security_policies (sys.security_policies)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.SecurityPolicy> SecurityPolicies { get; set; }Property Value
SecurityPredicates
security_predicates (sys.security_predicates)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SecuritySchema.SecurityPredicate> SecurityPredicates { get; set; }Property Value
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
Sequences
sequences (sys.sequences)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Sequence> Sequences { get; set; }Property Value
ServerAssemblyModules
server_assembly_modules (sys.server_assembly_modules)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerAssemblyModule> ServerAssemblyModules { get; set; }Property Value
ServerEventNotifications
server_event_notifications (sys.server_event_notifications)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerEventNotification> ServerEventNotifications { get; set; }Property Value
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
ServerEvents
server_events (sys.server_events)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerEvent> ServerEvents { get; set; }Property Value
ServerSqlModules
server_sql_modules (sys.server_sql_modules)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerSqlModule> ServerSqlModules { get; set; }Property Value
ServerTriggers
server_triggers (sys.server_triggers)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.ServerTrigger> ServerTriggers { get; set; }Property Value
ServiceQueue
service_queues (sys.service_queues)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ServiceBrokerSchema.ServiceQueue? ServiceQueue { get; set; }Property Value
SpatialIndexTessellations
spatial_index_tessellations (sys.spatial_index_tessellations)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SpatialDataSchema.SpatialIndexTessellation> SpatialIndexTessellations { get; set; }Property Value
SpatialIndexes
spatial_indexes (sys.spatial_indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<SpatialDataSchema.SpatialIndex> SpatialIndexes { get; set; }Property Value
SqlDependencies
sql_dependencies (sys.sql_dependencies)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.SqlDependency> SqlDependencies { get; set; }Property Value
SqlModules
sql_modules (sys.sql_modules)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.SqlModule> SqlModules { get; set; }Property Value
Stats
stats (sys.stats)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Stat> Stats { get; set; }Property Value
StatsColumns
stats_columns (sys.stats_columns)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.StatsColumn> StatsColumns { get; set; }Property Value
Synonym
synonyms (sys.synonyms)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.Synonym? Synonym { get; set; }Property Value
Table
tables (sys.tables)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.Table? Table { get; set; }Property Value
TriggerEvents
trigger_events (sys.trigger_events)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.TriggerEvent> TriggerEvents { get; set; }Property Value
Triggers
triggers (sys.triggers)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<ObjectSchema.Trigger> Triggers { get; set; }Property Value
TypeColumn
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
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
EC = Edge constraint
Applies to: SQL Server 2012 (11.x) and later.
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
TT = Table type
UQ = UNIQUE constraint
X = Extended stored procedure
Applies to: SQL Server 2014 (12.x) and later, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW).
ST = STATS_TREE
Applies to: SQL Server 2016 (13.x) and later, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW).
ET = External Table
[Column("type")]
[Nullable]
public string? TypeColumn { get; set; }Property Value
TypeDesc
Description of the object type:
AGGREGATE_FUNCTION
CHECK_CONSTRAINT
CLR_SCALAR_FUNCTION
CLR_STORED_PROCEDURE
CLR_TABLE_VALUED_FUNCTION
CLR_TRIGGER
DEFAULT_CONSTRAINT
EXTENDED_STORED_PROCEDURE
FOREIGN_KEY_CONSTRAINT
INTERNAL_TABLE
PLAN_GUIDE
PRIMARY_KEY_CONSTRAINT
REPLICATION_FILTER_PROCEDURE
RULE
SEQUENCE_OBJECT
Applies to: SQL Server 2012 (11.x) and later.
SERVICE_QUEUE
SQL_INLINE_TABLE_VALUED_FUNCTION
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
SYNONYM
SYSTEM_TABLE
TABLE_TYPE
UNIQUE_CONSTRAINT
USER_TABLE
VIEW
[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }Property Value
View
views (sys.views)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public ObjectSchema.View? View { get; set; }Property Value
XmlIndexes
xml_indexes (sys.xml_indexes)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = true)]
public IList<XmlSchema.XmlIndex> XmlIndexes { get; set; }