Class InformationSchema.Parameter

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

PARAMETERS (Transact-SQL)

Applies to: √ SQL Server √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW) √ SQL analytics endpoint in Microsoft Fabric √ Warehouse in Microsoft Fabric

Returns one row for each parameter of a user-defined function or stored procedure that can be accessed by the current user in the current database. For functions, this view also returns one row with return value information.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.*view_name*.

See INFORMATION_SCHEMA.PARAMETERS.

[Table(Schema = "INFORMATION_SCHEMA", Name = "PARAMETERS", IsView = true)]
public class InformationSchema.Parameter

Inheritance

object

InformationSchema.Parameter

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

AsLocator

AS_LOCATOR NULL nvarchar(

Returns YES if declared as locator. Otherwise, returns NO.

[Column("AS_LOCATOR")]
[Nullable]
public string? AsLocator { get; set; }

Property Value

string

CharacterMaximumLength

CHARACTER_MAXIMUM_LENGTH NULL int

Maximum length in characters for binary or character data types.

-1 for xml and large-value type data. Otherwise, returns NULL.

[Column("CHARACTER_MAXIMUM_LENGTH")]
[Nullable]
public int? CharacterMaximumLength { get; set; }

Property Value

int?

CharacterOctetLength

CHARACTER_OCTET_LENGTH NULL int

Maximum length, in bytes, for binary or character data types.

-1 for xml and large-value type data. Otherwise, returns NULL.

[Column("CHARACTER_OCTET_LENGTH")]
[Nullable]
public int? CharacterOctetLength { get; set; }

Property Value

int?

CharacterSetCatalog

CHARACTER_SET_CATALOG NULL nvarchar(

Catalog name of the character set of the parameter. If not one of the character types, returns NULL.

[Column("CHARACTER_SET_CATALOG")]
[Nullable]
public string? CharacterSetCatalog { get; set; }

Property Value

string

CharacterSetName

CHARACTER_SET_NAME NULL nvarchar(

Name of the character set of the parameter. If not one of the character types, returns NULL.

[Column("CHARACTER_SET_NAME")]
[Nullable]
public string? CharacterSetName { get; set; }

Property Value

string

CharacterSetSchema

CHARACTER_SET_SCHEMA NULL nvarchar(

Always returns NULL.

[Column("CHARACTER_SET_SCHEMA")]
[Nullable]
public string? CharacterSetSchema { get; set; }

Property Value

string

CollationCatalog

COLLATION_CATALOG NULL nvarchar(

Always returns NULL.

[Column("COLLATION_CATALOG")]
[Nullable]
public string? CollationCatalog { get; set; }

Property Value

string

CollationName

COLLATION_NAME NULL nvarchar(

Name of the collation of the parameter. If not one of the character types, returns NULL.

[Column("COLLATION_NAME")]
[Nullable]
public string? CollationName { get; set; }

Property Value

string

CollationSchema

COLLATION_SCHEMA NULL nvarchar(

Always returns NULL.

[Column("COLLATION_SCHEMA")]
[Nullable]
public string? CollationSchema { get; set; }

Property Value

string

DataType

DATA_TYPE NOT NULL nvarchar(

System-supplied data type.

[Column("DATA_TYPE")]
[NotNull]
public string DataType { get; set; }

Property Value

string

DatetimePrecision

DATETIME_PRECISION NULL smallint

Precision in fractional seconds if the parameter type is datetime or smalldatetime. Otherwise, returns NULL.

[Column("DATETIME_PRECISION")]
[Nullable]
public short? DatetimePrecision { get; set; }

Property Value

short?

IntervalPrecision

INTERVAL_PRECISION NULL smallint

NULL. Reserved for future use.

[Column("INTERVAL_PRECISION")]
[Nullable]
public short? IntervalPrecision { get; set; }

Property Value

short?

IntervalType

INTERVAL_TYPE NULL nvarchar(

NULL. Reserved for future use.

[Column("INTERVAL_TYPE")]
[Nullable]
public string? IntervalType { get; set; }

Property Value

string

IsResult

IS_RESULT NULL nvarchar(

Returns YES if indicates result of the routine that is a function. Otherwise, returns NO.

[Column("IS_RESULT")]
[Nullable]
public string? IsResult { get; set; }

Property Value

string

NumericPrecision

NUMERIC_PRECISION NULL tinyint

Precision of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.

[Column("NUMERIC_PRECISION")]
[Nullable]
public byte? NumericPrecision { get; set; }

Property Value

byte?

NumericPrecisionRadix

NUMERIC_PRECISION_RADIX NULL smallint

Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.

[Column("NUMERIC_PRECISION_RADIX")]
[Nullable]
public short? NumericPrecisionRadix { get; set; }

Property Value

short?

NumericScale

NUMERIC_SCALE NULL tinyint

Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.

[Column("NUMERIC_SCALE")]
[Nullable]
public byte? NumericScale { get; set; }

Property Value

byte?

OrdinalPosition

ORDINAL_POSITION NOT NULL int

Ordinal position of the parameter starting at 1. For the return value of a function, this is a 0.

[Column("ORDINAL_POSITION")]
[NotNull]
public int OrdinalPosition { get; set; }

Property Value

int

ParameterMode

PARAMETER_MODE NULL nvarchar(

Returns IN if an input parameter, OUT if an output parameter, and INOUT if an input/output parameter.

[Column("PARAMETER_MODE")]
[Nullable]
public string? ParameterMode { get; set; }

Property Value

string

ParameterName

PARAMETER_NAME NULL nvarchar(

Name of the parameter. NULL if this corresponds to the return value of a function.

[Column("PARAMETER_NAME")]
[Nullable]
public string? ParameterName { get; set; }

Property Value

string

ScopeCatalog

SCOPE_CATALOG NULL nvarchar(

NULL. Reserved for future use.

[Column("SCOPE_CATALOG")]
[Nullable]
public string? ScopeCatalog { get; set; }

Property Value

string

ScopeName

SCOPE_NAME NULL nvarchar(

NULL. Reserved for future use.

[Column("SCOPE_NAME")]
[Nullable]
public string? ScopeName { get; set; }

Property Value

string

ScopeSchema

SCOPE_SCHEMA NULL nvarchar(

NULL. Reserved for future use.

[Column("SCOPE_SCHEMA")]
[Nullable]
public string? ScopeSchema { get; set; }

Property Value

string

SpecificCatalog

SPECIFIC_CATALOG NULL nvarchar(

Catalog name of the routine for which this is a parameter.

[Column("SPECIFIC_CATALOG")]
[Nullable]
public string? SpecificCatalog { get; set; }

Property Value

string

SpecificName

SPECIFIC_NAME NOT NULL nvarchar(

Name of the routine for which this is a parameter.

[Column("SPECIFIC_NAME")]
[NotNull]
public string SpecificName { get; set; }

Property Value

string

SpecificSchema

SPECIFIC_SCHEMA NULL nvarchar(

Name of the schema of the routine for which this is a parameter.

Important: Don't use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view.

[Column("SPECIFIC_SCHEMA")]
[Nullable]
public string? SpecificSchema { get; set; }

Property Value

string

UserDefinedTypeCatalog

USER_DEFINED_TYPE_CATALOG NULL nvarchar(

NULL. Reserved for future use.

[Column("USER_DEFINED_TYPE_CATALOG")]
[Nullable]
public string? UserDefinedTypeCatalog { get; set; }

Property Value

string

UserDefinedTypeName

USER_DEFINED_TYPE_NAME NULL nvarchar(

NULL. Reserved for future use.

[Column("USER_DEFINED_TYPE_NAME")]
[Nullable]
public string? UserDefinedTypeName { get; set; }

Property Value

string

UserDefinedTypeSchema

USER_DEFINED_TYPE_SCHEMA NULL nvarchar(

NULL. Reserved for future use.

[Column("USER_DEFINED_TYPE_SCHEMA")]
[Nullable]
public string? UserDefinedTypeSchema { get; set; }

Property Value

string