Metadata routines are used to obtain information about - drivers and data sources - the implementation - the catalog
The following table shows these routines defined by SQL/CLI, ODBC and DBI: SQL/CLI ODBC DBI ----------------- -------------------- --------------------- - SQLDrivers available_drivers DataSources SQLDataSources data_sources ----------------- -------------------- --------------------- GetFeatureInfo - - GetFunctions SQLGetFunctions - GetInfo SQLGetInfo get_info GetSessionInfo - - ----------------- -------------------- --------------------- GetTypeInfo SQLGetTypeInfo type_info ----------------- -------------------- --------------------- ColumnPrivileges SQLColumnPrivileges - Columns SQLColumns column_info ForeignKeys SQLForeignKeys foreign_key_info PrimaryKeys SQLPrimaryKeys primary_key_info - SQLProcedureColumns - - SQLProcedures - SpecialColumns SQLSpecialColumns - - SQLStatistics - TablePrivileges SQLTablePrivileges - Tables SQLTables table_info ----------------- -------------------- --------------------- In my opinion, DBI supports the most important routines and I would assign the missing functions less priorities. Nevertheless, I like to help on filling the gaps. Thus I want to know: - What should be placed on top of the TODO list? - Are there any functions that DBI should never support? Steffen
