Moiz Saifuddin
asked on
Delete records
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();
Last Comment
ASKER
Error message from source "Microsoft OLE DB Provider for SQL Server"
ASKER
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
https://www.geeksforgeeks.org/sql-delete-statement/?ref=lbp
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
'delete from table' 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
https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15
Databases
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.
62K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Delete from <tablename>
This will delete entire rows unless restricts through a where clause.