<div>
select 'drop table '+table_name<br />
from information_schema
</div>


select 'drop table '+table_name
from information_schema

<div>
do you want to DELETE the data, or the complete table definition (DROP) ?<br />

<pre><code id="code-183485">exec sp_msForEachTable 'DELETE FROM ?' 
resp: 
exec sp_msForEachTable 'DROP TABLE ?'
</code></pre>
</div>


do you want to DELETE the data, or the complete table definition (DROP) ?


exec sp_msForEachTable 'DELETE FROM ?' 
resp: 
exec sp_msForEachTable 'DROP TABLE ?'


<div>
Hi there:<br />
<br />
To drop all tables in a SQL Server 2005 database use : <br />
<br />
sp_MSforeachtable command1 [,replacechar] [, command2] [,command3] [,whereand] [,precommand] [,postcommand <br />
<br />
Example : exec sp_MSforeachtable &quot;DROP TABLE ? PRINT '? dropped' &quot;&nbsp;<br />
<br />
Best regards...
</div>


Hi there:

To drop all tables in a SQL Server 2005 database use :

sp_MSforeachtable command1 [,replacechar] [, command2] [,command3] [,whereand] [,precommand] [,postcommand

Example : exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' " 

Best regards...

<div>
There are some simple queries you can use too...<br />
I have a SQL2000 database here and with this I get a list of all my (user) tables.<br />
select name from sysobjects where xtype = 'U'<br />
Then with curser or text editor I basically issue<br />
drop table tablename1<br />
drop table tablename2<br />
etc...
</div>


There are some simple queries you can use too...
I have a SQL2000 database here and with this I get a list of all my (user) tables.
select name from sysobjects where xtype = 'U'
Then with curser or text editor I basically issue
drop table tablename1
drop table tablename2
etc...

<div>
<div class="content wysiwyg-content">
hello there,<br />
<br />
how can i delete all the tables from my hosting sql server 2005 database.one way is to right clcik and select delete.but this is tds since i have more then 30 tables.thanks.<br />
<br />
cheers<br />
ZOlf
</div>
</div>


hello there,

how can i delete all the tables from my hosting sql server 2005 database.one way is to right clcik and select delete.but this is tds since i have more then 30 tables.thanks.

cheers
ZOlf

Delete all tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.