<div>
TRUNCATE TABLE table_name would be the fastest as it's minimally logged, but there are a couple of restrictions such as foreign keys that may prevent you from being able to do this. <br />
<br />
DELETE FROM table_name would also work, and it's fully logged so slower.
</div>


<div>
We can use delete and truncate commands to remove all data from the tables.<br />
<br />
Truncate table tablename<br />
<br />
Delete from tablename<br />
<br />
Truncate is faster than delete as it is minimally logged and will reseed identity column if any is there.
</div>


<div>
what would the statement be though?<br />
<br />
delete or truncate:<br />
delete from tablename<br />
(sample data, sample data 2);<br />
&nbsp;commit:
</div>


<div>
keep getting an error message that the sql command isn't properly ended
</div>


<div>
Use one of them like below.<br />
<br />
Truncate table tablename
</div>


<div>
&gt;what would the statement be though?<br />
We already told you. <br />
<br />
Check out Microsoft's explanations of <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql" rel="ugc">TRUNCATE TABLE</a> and <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql" rel="ugc">DELETE</a>, and if you scroll down to the bottom of each article there will be multiple examples.
</div>


<div>
thanks...you didn't actually tell me though...not trying to be harsh but turnabout is fair play...I'm very new to sql and doing this since my developer is out for the holiday...reaching out to experts is the best option I have...don't expect me to be an expert and know what you mean by simply stating that's what I need to do w/o code examples
</div>


<div>
Hi<br />
Please use <br />
<br />
Truncate table tablename<br />
<br />
Or below<br />
<br />
Delete from tablename<br />
<br />
- you need to provide the tablename of ur actual database table.
</div>


<div>
&gt;thanks...you didn't actually tell me though<br />
Actually I did, but since you didn't tell us the table name or any other code we could use to better answer your question then you'll need to subsitute table_name for whatever that is. &nbsp; You wouldn't believe how many times we get asked to 'fix my code' without any code given to work with. <br />
<br />
For a highly entertaining read that works well with your situation check out <a href="https://www.experts-exchange.com/articles/18499/Top-10-Ways-to-Ask-Better-Questions.html" rel="ugc">Top 10 Ways to Ask Better Questions. </a>
</div>


<div>
You can try this if there are relations between tables<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42378405-1"><span>EXEC sp_MSForEachTable 'DISABLE TRIGGER ALL ON ?'</span>
<span>GO</span>
<span>EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'</span>
<span>GO</span>
<span>EXEC sp_MSForEachTable 'DELETE FROM ?'</span>
<span>GO</span>
<span>EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'</span>
<span>GO</span>
<span>EXEC sp_MSForEachTable 'ENABLE TRIGGER ALL ON ?'</span>
<span>GO</span>
<span></span>
<span></span>
<span>exec sp_MSforeachtable @command1 = 'DBCC CHECKIDENT(''?'', RESEED, 0)'</span>
</code></pre>
</div>


<div>
Do not use this sp_MSForEachTable. This is undocumented. Also why so much of complicated code when single command works.
</div>


<div>
If there are 100 tables then that will be useful and I am using the same query when ever needed.
</div>


<div>
for that we can use a while loop.
</div>


<div>
To the original poster:<br />
<br />
<b>DON'T</b> arbitrarily disable <i>all</i> constraints on a table. It's extraordinarily dangerous, and it's often very difficult to get them all properly working again once you do so. &nbsp;You have to get SQL to &quot;trust&quot; them again, or they're worthless to your queries, but still cause overhead.<br />
<br />
Instead:<br />
IF the table has so many rows you really need to use TRUNCATE rather than DELETE, <br />
AND there are foreign key constraints that prevent you from using TRUNCATE<br />
<i>AND you can't instead just delete in batches instead</i><br />
THEN let me know and I'll give you an alternative that disables only the conflicting constraints.
</div>


<div>
As has been said you can use either TRUNCATE or DELETE.<br />
<br />
Truncate table is a command that behind the scenes just deallocates the pages and logs the deallocations, where DELETE will log the row deletes. &nbsp;The syntax has been shown in above posts. The decision will really be about any constraints (FK, etc) that will prevent you from using TRUNCATE TABLE and then you will use DELETE FROM tablename.<br />
<br />
Not sure there is anything more to say here.
</div>


<div>
worked after a little adjustment...thanks
</div>


<div>
<div class="content wysiwyg-content">
How do I drop all data w/in a sql table but keep the table? I need to keep the table/s but clear the data from w/in the tables.
</div>
</div>


How do I drop all data w/in a sql table but keep the table? I need to keep the table/s but clear the data from w/in the tables.

How do I drop all data w/in a sql table but keep the table?

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.