Other Database Operations

odbc_create_table('TableName','FIELDs')

FIELDS is the field specification as in SQL.

eg. odbc_create_table('MyTable', 'Col1 NUMBER,
                             Col2 TEXT(50),
                             Col3 TEXT(13)').

odbc_create_index('TableName','IndexName', index(_,Fields))

Fields is the list of columns for which an index is requested. For example:

odbc_create_index('Doctor', 'DocKey', index(_,'DId')).

odbc_delete_table('TableName')

To delete a table named 'TableName'

odbc_delete_view('ViewName')

To delete a view named 'ViewName'

odbc_delete_index('IndexName')

To delete an index named 'IndexName'

These following predicates are the supported PRODBI syntax for deleting and inserting rows:

odbc_add_record('Floor',['Seventh Floor','7'])

arguments are a list composed of field values and the table name to insert the row.

odbc_delete_record('Floor', ['Seventh Floor',_])

to delete rows from 'Floor' matching the list of values mentioned in second argument.

For other SQL statements use odbc_sql/1 with the SQL statement as the first argument. For example:

odbc_sql('grant connect to fred identified by bloggs')).