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
LVL 1
sqlserverdbaAsked:
Who is Participating?
 
HndlWCareCommented:
Try "DELETE FROM dbname.dbo.tablename" instead.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Access uses 'DELETE *', SQL just uses 'DELETE'
0
 
sqlserverdbaAuthor Commented:
ah, morning blues. I copied the code and tried to execute.. I didn't write the code..
Thank you!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the split.  Good luck with your project.  -Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.