<div>
Which sql server?<br />
<br />
Delete from &lt;tablename&gt;<br />
<br />
<br />
This will delete entire rows unless restricts through a where clause.
</div>


<div>
Error message from source "Microsoft OLE DB Provider for SQL Server"
</div>


<div>
Although in this site below they mention delete * from... as a valid query to delete all the records<br><br><a href="https://www.geeksforgeeks.org/sql-delete-statement/?ref=lbp" rel="ugc">https://www.geeksforgeeks.org/sql-delete-statement/?ref=lbp</a>
</div>


_agx_

Moiz Saifuddin

<div>
'delete from table' will work but has overhead. &nbsp;If you want to remove ALL rows, look up truncate:<br />
<a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15</a>
</div>


Darran Brown

<div>
<div class="content wysiwyg-content fr-view">
<p>Is this delete statement correct as in syntax if wanted to delete all the records&nbsp;</p><p><br></p><p>delete * from &lt;TableName&gt;</p><p><br></p><p>Im getting an error on ExecuteNonQuery() and errmessage<span id="isPasted" style=" text-align: left;">&nbsp;= "Incorrect syntax near '*'."</span>&nbsp;</p><p><br></p><p><br></p><p><br></p><p><br></p><pre><code class="code-1 nolinks" id="code-10-29227693-1">if (rsBackup.RecordCount &gt; 0)<br style=" text-align: left;">{<br style=" text-align: left;">stgSQL = "DELETE * FROM SalesTaxCombos";<br style=" text-align: left;">DbCommand TempCommand = mdlG3Config.gdbTarget.Connection.CreateCommand();<br style=" text-align: left;">TempCommand.CommandText = stgSQL;<br style=" text-align: left;">UpgradeHelpers.DB.DbConnectionHelper.ResetCommandTimeOut(TempCommand);<br style=" text-align: left;">TempCommand.Transaction = UpgradeHelpers.DB.TransactionManager.GetCurrentTransaction(mdlG3Config.gdbTarget.Connection);<br style=" text-align: left;">TempCommand.ExecuteNonQuery();
</code></pre><p><br></p><p><br></p>
</div>
</div>



Is this delete statement correct as in syntax if wanted to delete all the records 
delete * from <TableName>
Im getting an error on ExecuteNonQuery() and errmessage
 = "Incorrect syntax near '*'."
 
if (rsBackup.RecordCount > 0)
{
stgSQL = "DELETE * FROM SalesTaxCombos";
DbCommand TempCommand = mdlG3Config.gdbTarget.Connection.CreateCommand();
TempCommand.CommandText = stgSQL;
UpgradeHelpers.DB.DbConnectionHelper.ResetCommandTimeOut(TempCommand);
TempCommand.Transaction = UpgradeHelpers.DB.TransactionManager.GetCurrentTransaction(mdlG3Config.gdbTarget.Connection);
TempCommand.ExecuteNonQuery();


Which sql server?

Delete from &lt;tablename&gt;


This will delete entire rows unless restricts through a where clause.


Error message from source &quot;Microsoft OLE DB Provider for SQL Server&quot;


Although in this site below they mention delete * from... as a valid query to delete all the records
https://www.geeksforgeeks.org/sql-delete-statement/?ref=lbp

&#39;delete from table&#39; will work but has overhead.  If you want to remove ALL rows, look up truncate:
https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15

Delete records


Is this delete statement correct as in syntax if wanted to delete all the records 
delete * from &lt;TableName&gt;
Im getting an error on ExecuteNonQuery() and errmessage
 = &quot;Incorrect syntax near &#39;*&#39;.&quot;
 
if (rsBackup.RecordCount &gt; 0)
{
stgSQL = &quot;DELETE * FROM SalesTaxCombos&quot;;
DbCommand TempCommand = mdlG3Config.gdbTarget.Connection.CreateCommand();
TempCommand.CommandText = stgSQL;
UpgradeHelpers.DB.DbConnectionHelper.ResetCommandTimeOut(TempCommand);
TempCommand.Transaction = UpgradeHelpers.DB.TransactionManager.GetCurrentTransaction(mdlG3Config.gdbTarget.Connection);
TempCommand.ExecuteNonQuery();


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.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.