>>You could do a SELECT 0 before the create table.
>>
>>USED('tablealias') will let you see if a table is open.
>>
>
>But only if you use the right alias. I'm maintaining an app where, as originally written, different modules used the same table with 3 different aliases.
>
>Regards,

Then use the AUSED() function. If you pass it a full path and table name, it will tell you what aliases that table is opened under.