drop and create table

arnie_nits · Post by **arnie_nits** » Thu Oct 15, 2009 7:55 am

Hi,

Is it possible to drop and create table?

Regards,
Arnie.

ArndW · Post by **ArndW** » Thu Oct 15, 2009 7:58 am

Yes, it is possible to drop and create tables - in principle.
The question is what kind of tables using what kind of database access?

arnie_nits · Post by **arnie_nits** » Thu Oct 15, 2009 8:04 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Oct 15, 2009 8:47 am

Maybe you need 'truncate' and not 'drop'.

ArndW · Post by **ArndW** » Thu Oct 15, 2009 8:50 am

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?