Delete more than 1 table

[Dazza]

I need to delete approx 300 tables from a database. Does anyone know the best way to do this.. Thanking you in advance.

[Patrick]

You could investigate & eventually use "Truncate table"
more quicker than the delete in your 3 hundreds tables.
Thx
Patrick


------------
Dazza at 7/9/01 4:34:17 AM

I need to delete approx 300 tables from a database. Does anyone know the best way to do this.. Thanking you in advance.

[dallas]

In your position (if you want to completely delete all 300 tables, rather than just truncate them) I would generate an SQL script on the DB selecting a drop object and edit the script from there. If you need more details, email me. HTH, Dallas
------------
Patrick at 7/9/01 6:57:44 AM

You could investigate & eventually use "Truncate table"
more quicker than the delete in your 3 hundreds tables.
Thx
Patrick


------------
Dazza at 7/9/01 4:34:17 AM

I need to delete approx 300 tables from a database. Does anyone know the best way to do this.. Thanking you in advance.

[Jun]

Open your Enterprise Manager -> Expand the databases -> Double Click
the target database (if all your three hundreds tables are in one DB)
-> Click tables and on the right panel where the table names showing.
Click the tables (you want to delete) one by one while holding down the "Ctrl" key, Right click any of the highted table, Click "Delete". You will be asked for confirmation of the deletion. Hope this works for you!

Jun


------------
Dazza at 7/9/01 4:34:17 AM

I need to delete approx 300 tables from a database. Does anyone know the best way to do this.. Thanking you in advance.