Rich Metadata

ODBC defines a wide range of metadata functions that provide information both about the structure of the data in the database and the datatypes supported by the database. The following table lists the functions and shows which are supported by the Win32::ODBC and DBI modules.

ODBC Function

Win32::ODBC

DBI

Tables

image with no caption

TablePrivileges

  

Columns

 

ColumnPrivileges

  

SpecialColumns

 

Statistics

 

PrimaryKeys

 

ForeignKeys

 

Procedures

  

ProcedureColumns

  

GetTypeInfo

image with no caption

As you can see, the DBI lags behind the Win32::ODBC module. By the time you read this book, ...

Get Programming the Perl DBI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.