Search Results for

    Show / Hide Table of Contents

    Class NpgsqlDbColumn

    Provides schema information about a column.

    Inheritance
    object
    NpgsqlDbColumn
    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 Source

    NpgsqlDbColumn()

    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 Source

    AllowDBNull

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    | Improve this Doc View Source

    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.

    • Improve this Doc
    • View Source
    In This Article
    Back to top © Copyright 2023 The Npgsql Development Team