Get Column Metadata

Get information about columns in specified table(s).

Usage

getColumnMetadata(db, table_names = NULL)

Arguments

db

A com.healthmarketscience.jackcess.Database object (e.g. created by Database())

table_names

character. Database table name. Default NULL will return metadata for all tables in db.

Value

data.frame containing database name (database_name; character), table name (table_name; character), column name (column_name; character), column data type (datatype; character), column length (length; integer), column length in units (lengthinunits; integer), column precision (precision; integer), column scale (scale; integer), column SQL type (sqltype; integer), column "is append only? (appendonly; logical), column "is autonumber?" (autonumber; logical), column "is calculated?" (calculated; logical), column "is compressed unicode?" (compressedunicode; logical), column "is hyperlink?" (hyperlink; logical), column "is variable length?" (variablelength; logical)

See also

Database getTableNames