• Places
    • Home
    • Graphs
    • Prefixes
  • Admin
    • Users
    • Settings
    • Plugins
    • Statistics
  • CPACK
    • Home
    • List packs
    • Submit pack
  • Repository
    • Load local file
    • Load from HTTP
    • Load from library
    • Remove triples
    • Clear repository
  • Query
    • YASGUI SPARQL Editor
    • Simple Form
    • SWISH Prolog shell
  • Help
    • Documentation
    • Tutorial
    • Roadmap
    • HTTP Services
  • Login

2.5 Accessing the database dictionary
All Application Manual Name SummaryHelp

  • 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.
ClioPatria (version V3.1.1-51-ga0b30a5)