2.5 Accessing the database dictionary
AllApplicationManualNameSummaryHelp

  • Documentation
    • Reference manual
    • Packages
      • SWI-Prolog ODBC Interface
        • The ODBC layer
          • Accessing the database dictionary
            • odbc_current_table/2
            • odbc_current_table/3
            • odbc_table_column/3
            • odbc_table_column/4
            • odbc_type/3
            • odbc_table_primary_key/3
            • odbc_table_foreign_key/5
Availability::- use_module(library(odbc)).(can be autoloaded)
Sourceodbc_table_column(+Connection, ?Table, ?Column, ?Facet)
Provides access to the properties of the table as defined by the ODBC call SQLColumns(). Defined facets are:
table_qualifier(Qualifier)
table_owner(Owner)
table_name(Table)
See odbc_current_table/3.
data_type(DataType)
type_name(TypeName)
precision(Precision)
length(Length)
scale(Scale)
radix(Radix)
nullable(Nullable)
remarks(Remarks)
These facets are defined by SQLColumns()
type(Type)
More prolog-friendly representation of the type properties. See section 2.7.