Subject | Re: [IBO] Re: Object in use when dropping table (255 something limit) |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-07-25T10:57:57Z |
>I cannot immediately see how this would affect the creation and deletion ofT1, T2, >T3,
>tables. What would happen for example if one created and dropped tables
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