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'