Need help on cleaning up database

General
N/A

Need help on cleaning up database

Hi,

 

For Analysis, I created multiple tables and half or them are not used in my reports. Is there an easy way to clean the database?

 

Thanks

Sonia

 


Accepted Solutions

Re: Need help on cleaning up database

Hi,

 

Well, I suppose that depends on your definition of 'easy' :-)

 

If you need to keep some tables and remove some and assuming that the ones to be kept cannot 'easily' be re-created then you're looking at one of the following processes:

- copy all tables to be kept into another database, use 'delete database' against the real one, copy all tables back

- generate 'drop table' commands for all the tables that you need to remove

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
1 REPLY

Re: Need help on cleaning up database

Hi,

 

Well, I suppose that depends on your definition of 'easy' :-)

 

If you need to keep some tables and remove some and assuming that the ones to be kept cannot 'easily' be re-created then you're looking at one of the following processes:

- copy all tables to be kept into another database, use 'delete database' against the real one, copy all tables back

- generate 'drop table' commands for all the tables that you need to remove

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com