Class CompatibilitySchema.Column
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.syscolumns (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Returns one row for every column in every table and view, and a row for each parameter in a stored procedure in the database.
important
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
See sys.syscolumns.
[Table(Schema = "sys", Name = "syscolumns", IsView = true)]
public class CompatibilitySchema.Column- Inheritance
-
CompatibilitySchema.Column
- Extension Methods
Properties
AutoVal
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("autoval")]
[Nullable]
public byte[]? AutoVal { get; set; }Property Value
- byte[]
BitPos
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("bitpos")]
[Nullable]
public byte? BitPos { get; set; }Property Value
- byte?
CDefault
ID of the default for this column.
[Column("cdefault")]
[NotNull]
public int CDefault { get; set; }Property Value
ColStat
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("colstat")]
[Nullable]
public short? ColStat { get; set; }Property Value
Collation
Name of the collation of the column. NULL if not a character-based column.
[Column("collation")]
[Nullable]
public string? Collation { get; set; }Property Value
CollationID
ID of the collation of the column. NULL for noncharacter-based columns.
[Column("collationid")]
[Nullable]
public int? CollationID { get; set; }Property Value
- int?
ColorDer
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("colorder")]
[Nullable]
public short? ColorDer { get; set; }Property Value
ColumnID
Column or parameter ID.
[Column("colid")]
[Nullable]
public short? ColumnID { get; set; }Property Value
Domain
ID of the rule or CHECK constraint for this column.
[Column("domain")]
[NotNull]
public int Domain { get; set; }Property Value
ID
Object ID of the table to which this column belongs, or the ID of the stored procedure with which this parameter is associated.
[Column("id")]
[NotNull]
public int ID { get; set; }Property Value
IsComputed
Flag indicating whether the column is computed:
0 = Noncomputed
1 = Computed
[Column("iscomputed")]
[Nullable]
public int? IsComputed { get; set; }Property Value
- int?
IsNullable
Indicates whether the column allows null values:
1 = True
0 = False
[Column("isnullable")]
[Nullable]
public int? IsNullable { get; set; }Property Value
- int?
IsOutParam
Indicates whether the procedure parameter is an output parameter:
1 = True
0 = False
[Column("isoutparam")]
[Nullable]
public int? IsOutParam { get; set; }Property Value
- int?
Length
Maximum physical storage length from sys.types.
[Column("length")]
[NotNull]
public short Length { get; set; }Property Value
Name
Name of the column or procedure parameter.
[Column("name")]
[Nullable]
public string? Name { get; set; }Property Value
Number
Subprocedure number when the procedure is grouped.
0 = Nonprocedure entries
[Column("number")]
[Nullable]
public short? Number { get; set; }Property Value
Offset
Offset into the row in which this column appears.
[Column("offset")]
[Nullable]
public short? Offset { get; set; }Property Value
Prec
Level of precision for this column.
-1 = xml or large value type.
[Column("prec")]
[Nullable]
public short? Prec { get; set; }Property Value
PrintFmt
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("printfmt")]
[Nullable]
public string? PrintFmt { get; set; }Property Value
Reserved
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("reserved")]
[Nullable]
public byte? Reserved { get; set; }Property Value
- byte?
Scale
Scale for this column.
NULL = Data type is nonnumeric.
[Column("scale")]
[Nullable]
public int? Scale { get; set; }Property Value
- int?
Status
Bitmap used to describe a property of the column or the parameter:
0x08 = Column allows null values.
0x10 = ANSI padding was in effect when varchar or varbinary columns were added. Trailing blanks are preserved for varchar and trailing zeros are preserved for varbinary columns.
0x40 = Parameter is an OUTPUT parameter.
0x80 = Column is an identity column.
[Column("status")]
[Nullable]
public byte? Status { get; set; }Property Value
- byte?
TypeColumn
Physical storage type from sys.types.
[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }Property Value
TypeStat
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("typestat")]
[Nullable]
public byte? TypeStat { get; set; }Property Value
- byte?
UserType
ID of user-defined data type from sys.types. Overflows or returns NULL if the number of data types exceeds 32,767.
[Column("usertype")]
[Nullable]
public short? UserType { get; set; }Property Value
XOffset
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("xoffset")]
[Nullable]
public short? XOffset { get; set; }Property Value
XPrec
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("xprec")]
[NotNull]
public byte XPrec { get; set; }Property Value
XScale
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("xscale")]
[NotNull]
public byte XScale { get; set; }Property Value
XType
Physical storage type from sys.types.
[Column("xtype")]
[NotNull]
public byte XType { get; set; }Property Value
XUserType
ID of extended user-defined data type. Overflows or returns NULL if the number of data types exceeds 32,767.
[Column("xusertype")]
[Nullable]
public short? XUserType { get; set; }