>I created a database and one table in it.

>If I start isql, connect to the database and then perform a simple
>select on the table I can no longer drop this table. I get 'object
>TABLE1 is in use' error. However if I restart isql and reconnect to
>the dabatase I can now drop the table (again, as long as I did not
>select from it). Is this normal?

Yes. It is in use until you commit or rollback the transaction that has performed the select. Exiting isql via exit causes a commit. Exiting isql via quit causes a rollback. You can cause the commit yourself by using the commit command in isql.

HTH,

Dan.