Table of Contents

Class SecuritySchema.SystemComponentsSurfaceAreaConfiguration

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

sys.system_components_surface_area_configuration (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns one row for each executable system object that can be enabled or disabled by a surface area configuration component. For more information, see Surface Area Configuration.


See sys.system_components_surface_area_configuration.

[Table(Schema = "sys", Name = "system_components_surface_area_configuration", IsView = true)]
public class SecuritySchema.SystemComponentsSurfaceAreaConfiguration
Inheritance
SecuritySchema.SystemComponentsSurfaceAreaConfiguration
Extension Methods

Properties

ComponentName

Component name. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.

[Column("component_name")]
[Nullable]
public string? ComponentName { get; set; }

Property Value

string

DatabaseName

Database that contains the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Must be one of the following:

master

msdb

mssqlsystemresource

[Column("database_name")]
[Nullable]
public string? DatabaseName { get; set; }

Property Value

string

ObjectName

Name of the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.

[Column("object_name")]
[NotNull]
public string ObjectName { get; set; }

Property Value

string

SchemaName

Schema that contains the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.

[Column("schema_name")]
[Nullable]
public string? SchemaName { get; set; }

Property Value

string

State

0 = Disabled

1 = Enabled

[Column("state")]
[Nullable]
public byte? State { get; set; }

Property Value

byte?

TypeColumn

Object type. Can be one of the following:

P = SQL_STORED_PROCEDURE

PC = CLR_STORED_PROCEDURE

FN = SQL_SCALAR_FUNCTION

FS = CLR_SCALAR_FUNCTION

FT = CLR_TABLE_VALUED_FUNCTION

IF = SQL_INLINE_TABLE_VALUED_FUNCTION

TF = SQL_TABLE_VALUED_FUNCTION

X = EXTENDED_STORED_PROCEDURE

[Column("type")]
[NotNull]
public string TypeColumn { get; set; }

Property Value

string

TypeDesc

Friendly name description of the object type.

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string