Class ObjectSchema.SystemSqlModule

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.system_sql_modules (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Returns one row per system object that contains an SQL language-defined module. System objects of type FN, IF, P, PC, TF, V have an associated SQL module. To identify the containing object, you can join this view to sys.system_objects.

See sys.system_sql_modules.

[Table(Schema = "sys", Name = "system_sql_modules", IsView = true)]
public class ObjectSchema.SystemSqlModule

Inheritance

object

ObjectSchema.SystemSqlModule

Extension Methods

Map.DeepCopy<T>(T)

Properties

Definition

SQL text that defines this module.

[Column("definition")]
[Nullable]
public string? Definition { get; set; }

Property Value

string

ExecuteAsPrincipalID

Always returns NULL

[Column("execute_as_principal_id")]
[Nullable]
public int? ExecuteAsPrincipalID { get; set; }

Property Value

int?

IsRecompiled

0 = Procedure was not created by using the WITH RECOMPILE option.

Always returns 0.

[Column("is_recompiled")]
[NotNull]
public bool IsRecompiled { get; set; }

Property Value

bool

IsSchemaBound

0 = Module was not created with the SCHEMABINDING option.

Always returns 0.

[Column("is_schema_bound")]
[NotNull]
public bool IsSchemaBound { get; set; }

Property Value

bool

NullOnNullInput

0 = Module was not created to produce a NULL output on any NULL input.

Always returns 0.

[Column("null_on_null_input")]
[NotNull]
public bool NullOnNullInput { get; set; }

Property Value

bool

ObjectID

Object identification number of the containing object, unique within a database.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

SystemObject

system_objects (sys.system_objects)

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

Property Value

ObjectSchema.SystemObject

UsesAnsiNulls

1 = Module was created with the SET ANSI_NULLS database option ON.

Always returns 1.

[Column("uses_ansi_nulls")]
[NotNull]
public bool UsesAnsiNulls { get; set; }

Property Value

bool

UsesDatabaseCollation

0 = Module does not depend on the default collation of the database.

Always returns 0.

[Column("uses_database_collation")]
[NotNull]
public bool UsesDatabaseCollation { get; set; }

Property Value

bool

UsesQuotedIdentifier

1 = Module was created with SET QUOTED_IDENTIFIER ON.

Always returns 1.

[Column("uses_quoted_identifier")]
[NotNull]
public bool UsesQuotedIdentifier { get; set; }

Property Value

bool