Class InformationSchema.Parameter
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
PARAMETERS (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 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_.
[Table(Schema = "INFORMATION_SCHEMA", Name = "PARAMETERS", IsView = true)]
public class InformationSchema.Parameter- Inheritance
-
InformationSchema.Parameter
- Extension Methods
Properties
AsLocator
Returns YES if declared as locator. Otherwise, returns NO.
[Column("AS_LOCATOR")]
[Nullable]
public string? AsLocator { get; set; }Property Value
CharacterMaximumLength
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
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
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
CharacterSetName
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
CharacterSetSchema
Always returns NULL.
[Column("CHARACTER_SET_SCHEMA")]
[Nullable]
public string? CharacterSetSchema { get; set; }Property Value
CollationCatalog
Always returns NULL.
[Column("COLLATION_CATALOG")]
[Nullable]
public string? CollationCatalog { get; set; }Property Value
CollationName
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
CollationSchema
Always returns NULL.
[Column("COLLATION_SCHEMA")]
[Nullable]
public string? CollationSchema { get; set; }Property Value
DataType
System-supplied data type.
[Column("DATA_TYPE")]
[NotNull]
public string DataType { get; set; }Property Value
DatetimePrecision
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
IntervalPrecision
NULL. Reserved for future use.
[Column("INTERVAL_PRECISION")]
[Nullable]
public short? IntervalPrecision { get; set; }Property Value
IntervalType
NULL. Reserved for future use.
[Column("INTERVAL_TYPE")]
[Nullable]
public string? IntervalType { get; set; }Property Value
IsResult
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
NumericPrecision
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
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
NumericScale
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 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
ParameterMode
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
ParameterName
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
ScopeCatalog
NULL. Reserved for future use.
[Column("SCOPE_CATALOG")]
[Nullable]
public string? ScopeCatalog { get; set; }Property Value
ScopeName
NULL. Reserved for future use.
[Column("SCOPE_NAME")]
[Nullable]
public string? ScopeName { get; set; }Property Value
ScopeSchema
NULL. Reserved for future use.
[Column("SCOPE_SCHEMA")]
[Nullable]
public string? ScopeSchema { get; set; }Property Value
SpecificCatalog
Catalog name of the routine for which this is a parameter.
[Column("SPECIFIC_CATALOG")]
[Nullable]
public string? SpecificCatalog { get; set; }Property Value
SpecificName
Name of the routine for which this is a parameter.
[Column("SPECIFIC_NAME")]
[NotNull]
public string SpecificName { get; set; }Property Value
SpecificSchema
Name of the schema of the routine for which this is a parameter.
Important Do not 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 a object is to query the sys.objects catalog view.
[Column("SPECIFIC_SCHEMA")]
[Nullable]
public string? SpecificSchema { get; set; }Property Value
UserDefinedTypeCatalog
NULL. Reserved for future use.
[Column("USER_DEFINED_TYPE_CATALOG")]
[Nullable]
public string? UserDefinedTypeCatalog { get; set; }Property Value
UserDefinedTypeName
NULL. Reserved for future use.
[Column("USER_DEFINED_TYPE_NAME")]
[Nullable]
public string? UserDefinedTypeName { get; set; }Property Value
UserDefinedTypeSchema
NULL. Reserved for future use.
[Column("USER_DEFINED_TYPE_SCHEMA")]
[Nullable]
public string? UserDefinedTypeSchema { get; set; }