Table of Contents

Class ObjectSchema.AllSqlModule

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

sys.all_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 the union of sys.sql_modules and sys.system_sql_modules.
The view returns a row for each natively compiled, scalar user-defined function. For more information, see Scalar User-Defined Functions for In-Memory OLTP.


See sys.all_sql_modules.

[Table(Schema = "sys", Name = "all_sql_modules", IsView = true)]
public class ObjectSchema.AllSqlModule
Inheritance
ObjectSchema.AllSqlModule
Extension Methods

Properties

AllObject

all_objects (sys.all_objects)

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

Property Value

ObjectSchema.AllObject

Definition

SQL text that defines this module.

NULL = Encrypted

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

Property Value

string

ExecuteAsPrincipalID

ID of the EXECUTE AS database principal.

NULL by default or if EXECUTE AS CALLER.

ID of the specified principal if EXECUTE AS SELF or EXECUTE AS <principal>.

-2 = EXECUTE AS OWNER.

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

Property Value

int?

IsRecompiled

Procedure was created using the WITH RECOMPILE option.

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

Property Value

bool?

IsSchemaBound

Module was created with the SCHEMABINDING option.

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

Property Value

bool?

NullOnNullInput

Module was declared to produce a NULL output on any NULL input.

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

Property Value

bool?

ObjectID

ID of the object of the containing object. Is unique within a database.

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

Property Value

int

UsesAnsiNulls

Module was created with SET ANSI_NULLS ON.

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

Property Value

bool?

UsesDatabaseCollation

1 = Schema-bound module definition depends on the default-collation of the database for correct evaluation; otherwise, 0. Such a dependency prevents changing the default collation of the database.

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

Property Value

bool?

UsesNativeCompilation

Applies to: SQL Server 2014 (12.x) and later.

0 = not natively compiled

1 = is natively compiled

The default value is 0.

[Column("uses_native_compilation")]
[Nullable]
public bool? UsesNativeCompilation { get; set; }

Property Value

bool?

UsesQuotedIdentifier

Module was created with SET QUOTED_IDENTIFIER ON.

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

Property Value

bool?