Subject | Drop Table...Advice please |
---|---|
Author | Dave Bullar |
Post date | 2001-08-09T14:46:32Z |
Hi everyone.
I want some temporary tables, which need to start empty,
but are used quite frequently.
From the point-of-view of Interbase and filling up the database is it better to:
A. empty the table (sql = 'delete from temptable') or
B drop the table and then re-create it .
sql = 'drop table temptable'
sql = 'create table temptable( .......'
Your Expert advice Please !!
Dave
[Non-text portions of this message have been removed]
I want some temporary tables, which need to start empty,
but are used quite frequently.
From the point-of-view of Interbase and filling up the database is it better to:
A. empty the table (sql = 'delete from temptable') or
B drop the table and then re-create it .
sql = 'drop table temptable'
sql = 'create table temptable( .......'
Your Expert advice Please !!
Dave
[Non-text portions of this message have been removed]