Subject Re: [IBO] Re: Object in use when dropping table (255 something limit)
Author Svein Erling Tysvær
>I cannot immediately see how this would affect the creation and deletion of
>tables. What would happen for example if one created and dropped tables
T1, T2, >T3,

It doesn't affect creation and deletion of tables since that is only two
alterations for each table. So creating and dropping three tables doesn't
cause any problems. The 256 (I thought it was 255) limitation is more of a
problem if you frequently issue ALTER commands - and most often encountered
by ALTER INDEX and ALTER TRIGGER statements.

But I still think creating and dropping tables frequently within a program
is bad practice and may signify a bad design.

Set