无法删除表格行 [英] Can not delete table row

问题描述

我在SQL Server 2008中有一个表。在表中没有主键。我无法删除数据库中的任何行。请给我一个解决方案。但是当我运行以下查询时，行删除DELETE TransactionInformation。非常感谢帮助我。

I have a table in SQL Server 2008. In the table there is no primary key. I can not delete any row in database. Please give me a solution.But when I run the following query then the rows delete "DELETE TransactionInformation". Advance thanks for helping me.

推荐答案

错误的删除语句语法 [ ^ ]，您需要 FROM 如下所示。

incorrect delete statement syntax[^], you need FROM like below.

DELETE  FROM yourtable

上面的
将删除所有行

above will delete all the rows

DELETE FROM yourtable Where column = 'someValue'

以上将删除符合条件的行

above will deleted the rows which match the condition

这篇关于无法删除表格行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！