Okay let's start with, I originally had an API compatible with ODBC, which the third information parameter is 'The name of the table, view, alias, or synonym.'
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/odbc/src/tpc/db2z_fncolumns.html Column 1 TABLE_CAT (VARCHAR(128))The name of the catalog. The value is NULL if this table does not have catalogs.Column 2 TABLE_SCHEM (VARCHAR(128))The name of the schema containing TABLE_NAME.Column 3 TABLE_NAME (VARCHAR(128) not NULL)The name of the table, view, alias, or synonym.Column 4 COLUMN_NAME (VARCHAR(128) not NULL)The column identifier. The name of the column of the specified table, view, alias, or synonym.Column 5 DATA_TYPE (SMALLINT not NULL)The SQL data type of the column that is identified by COLUMN_NAME. The DATA_TYPE is one of the values in the Symbolic SQL Data Type column in the table of symbolic and default data types for CLI.Column 6 TYPE_NAME (VARCHAR(128) not NULL)A character string that represents the name of the data type that corresponds to DATA_TYPE.Column 7 COLUMN_SIZE (INTEGER) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users