Link to home
Start Free TrialLog in
Avatar of sqlserverdba
sqlserverdba

asked on

sql delete rows error incorrect syntax

i tried a delete as below.
"delete * from dbname.dbo.tablename"

I got the following error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '*'.

I was not sure what this was about. please help. Thanks
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sqlserverdba
sqlserverdba

ASKER

ah, morning blues. I copied the code and tried to execute.. I didn't write the code..
Thank you!
Thanks for the split.  Good luck with your project.  -Jim