Table of Contents

Class ObjectSchema.NumberedProcedure

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

sys.numbered_procedures (Transact-SQL)

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

Contains a row for each SQL Server stored procedure that was created as a numbered procedure. This does not show a row for the base (number = 1) stored procedure. Entries for the base stored procedures can be found in views such as sys.objects and sys.procedures.

important


Numbered procedures are deprecated. Use of numbered procedures is discouraged. A DEPRECATION_ANNOUNCEMENT event is fired when a query that uses this catalog view is compiled.


See sys.numbered_procedures.

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

Properties

Definition

The SQL Server text that defines this procedure.

NULL = encrypted.

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

Property Value

string

Object

objects (sys.objects)

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

Property Value

ObjectSchema.Object

ObjectID

ID of the object of the stored procedure.

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

Property Value

int

ProcedureNumber

Number of this procedure within the object, 2 or greater.

[Column("procedure_number")]
[Nullable]
public short? ProcedureNumber { get; set; }

Property Value

short?