SQL Query Builder ยป Database Information Functions

db-tables(&key (schema *schema*) (transform (function identity)))
returns a list of table names of the schema.

schema: string or keyword representing schema

transform: function of one string variable to transform table names. use #'keyword-upcase for keyword names

db-table-columns(schema table &key (transform (function identity)))
returns a list of column names of the table.

schema: string or keyword representing schema

table: string or keyword representing the table

transform: function of one string variable to transform column names. use #'keyword-upcase for keyword names

db-primary-key(schema table &key (transform (function identity)))
returns two values constaint-schema e constraint-name of the primary key.

schema: string or keyword representing schema

table: string or keyword representing the table

transform: function of one string variable to transform the results. use #'keyword-upcase for keyword names

db-primary-key-columns(schema table &key (transform (function identity)))
returns a list of column names of the primary key of the table.

schema: string or keyword representing schema

table: string or keyword representing the table

transform: function of one string variable to transform column names. use #'keyword-upcase for keyword names