Delete query returns more rows than actually table has

[raykon]

Hi,
I have a table with 28 rows and when i want to run a query "delete * from table" it warnings"6329 rows will be deleted"
i can't understand. pls help.

 

[CJ_London]

nor can we without more information - what is the SQL to your delete query?

 

[raykon]

Delete * from table

 

[jleach]

Check and make sure you don't have a filter applied to the view on the table (deceiving you to believe there's only 28 rows while there is in fact much more: I'd sooner believe the database's warning).

Also make sure there's no joins in the table. Do you have the exact sql you run? Are there any saved select queries involved?

 

[CJ_London]

with respect providing generic code rather than the actual code doesn't help. However I'll throw in another possibility that the table is a parent table and has a child table with referential integrity set.

if 'table' is actually the name of your table you are using a reserved word. and using reserved words can create misleading errors.