Page 1 of 1
drop and create table
Posted: Thu Oct 15, 2009 7:55 am
by arnie_nits
Hi,
Is it possible to drop and create table?
Regards,
Arnie.
Posted: Thu Oct 15, 2009 7:58 am
by ArndW
Yes, it is possible to drop and create tables - in principle.
The question is what kind of tables using what kind of database access?
Posted: Thu Oct 15, 2009 8:04 am
by arnie_nits
Actually I want to run a job that will create a table in sql server.
This table will be used to generate reports. But for the next run I want to drop the existing table and re-create the same table.
Could please tell me how to do this....have never tried this before...
Regards,
Arnie.
Posted: Thu Oct 15, 2009 8:47 am
by Sainath.Srinivasan
Maybe you need 'truncate' and not 'drop'.
Posted: Thu Oct 15, 2009 8:50 am
by ArndW
A quick look at V8 shows that you can drop and create ODBC connection tables; I am pretty certain that is built in at V7. What stage are you using to write to SQL Server?