Class NpgsqlDbColumn
Provides schema information about a column.
Namespace: Npgsql.Schema
Assembly: Npgsql.dll
Syntax
public class NpgsqlDbColumn : DbColumn
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
Constructors
| Improve this Doc View SourceNpgsqlDbColumn()
Initializes a new instance of the NpgsqlDbColumn class.
Declaration
public NpgsqlDbColumn()
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
Properties
| Improve this Doc View SourceAllowDBNull
Declaration
public bool? AllowDBNull { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
BaseCatalogName
Declaration
public string BaseCatalogName { get; protected set; }
Property Value
Type | Description |
---|---|
string |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
BaseColumnName
Declaration
public string? BaseColumnName { get; protected set; }
Property Value
Type | Description |
---|---|
string? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
BaseSchemaName
Declaration
public string? BaseSchemaName { get; protected set; }
Property Value
Type | Description |
---|---|
string? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
BaseServerName
Declaration
public string BaseServerName { get; protected set; }
Property Value
Type | Description |
---|---|
string |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
BaseTableName
Declaration
public string? BaseTableName { get; protected set; }
Property Value
Type | Description |
---|---|
string? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
ColumnAttributeNumber
The column's position within its table. Note that this is different from ColumnOrdinal, which is the column's position within the resultset.
Declaration
public short? ColumnAttributeNumber { get; }
Property Value
Type | Description |
---|---|
short? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
ColumnName
Declaration
public string ColumnName { get; protected set; }
Property Value
Type | Description |
---|---|
string |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
ColumnOrdinal
Declaration
public int? ColumnOrdinal { get; protected set; }
Property Value
Type | Description |
---|---|
int? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
ColumnSize
Declaration
public int? ColumnSize { get; protected set; }
Property Value
Type | Description |
---|---|
int? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
DataType
Declaration
public Type? DataType { get; protected set; }
Property Value
Type | Description |
---|---|
Type? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
DataTypeName
Declaration
public string DataTypeName { get; protected set; }
Property Value
Type | Description |
---|---|
string |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
DefaultValue
The default SQL expression for this column.
Declaration
public string? DefaultValue { get; }
Property Value
Type | Description |
---|---|
string? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsAliased
Declaration
public bool? IsAliased { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsAutoIncrement
Declaration
public bool? IsAutoIncrement { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsIdentity
Declaration
public bool? IsIdentity { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsKey
Declaration
public bool? IsKey { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsLong
Declaration
public bool? IsLong { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsReadOnly
Declaration
public bool? IsReadOnly { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
IsUnique
Declaration
public bool? IsUnique { get; protected set; }
Property Value
Type | Description |
---|---|
bool? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
this[string]
Declaration
public override object? this[string propertyName] { get; }
Parameters
Type | Name | Description |
---|---|---|
string | propertyName |
Property Value
Type | Description |
---|---|
object? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
NpgsqlDbType
The NpgsqlDbType value for this column's type.
Declaration
public NpgsqlDbType? NpgsqlDbType { get; }
Property Value
Type | Description |
---|---|
NpgsqlDbType? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
NumericPrecision
Declaration
public int? NumericPrecision { get; protected set; }
Property Value
Type | Description |
---|---|
int? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
NumericScale
Declaration
public int? NumericScale { get; protected set; }
Property Value
Type | Description |
---|---|
int? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
PostgresType
The PostgresType describing the type of this column.
Declaration
public PostgresType PostgresType { get; }
Property Value
Type | Description |
---|---|
PostgresType |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
TableOID
The OID of the PostgreSQL table of this column.
Declaration
public uint TableOID { get; }
Property Value
Type | Description |
---|---|
uint |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
TypeOID
The OID of the type of this column in the PostgreSQL pg_type catalog table.
Declaration
public uint TypeOID { get; }
Property Value
Type | Description |
---|---|
uint |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.
UdtAssemblyQualifiedName
Declaration
public string? UdtAssemblyQualifiedName { get; protected set; }
Property Value
Type | Description |
---|---|
string? |
Remarks
Note that this can correspond to a field returned in a query which isn't an actual table column
See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.