<div>
Angel,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I learnt something new today. :)<br />
Thanks man
</div>


Angel,
          I learnt something new today. :)
Thanks man

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I need to delete all the datas in my database.<br />
I want to select all the tables (except the system tables), then delete all the datas in those tables to clear the database.<br />
<br />
Thanks in advance for your help.
</div>
</div>


Hi Experts,

I need to delete all the datas in my database.
I want to select all the tables (except the system tables), then delete all the datas in those tables to clear the database.

Thanks in advance for your help.

Delete all datas in the database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.