Query syntax error near "SELECT * FROM user"? [duplicate]

Question

Possible Duplicate:
Incorrect syntax near the keyword 'User'

I'm trying to use very simple SQL query in SQL Server Management Studio 2008, the exact query is:

SELECT * FROM User;

But it gives me error when I try to run this.

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'User'.

This table exists and when I try to select any other table data with this statement (by replacing table name), I get all data as I want. Have anyone ideas how to repair it? Tried to google it, but didn't get answers.

SQL Server is decent about reporting this type of error (as opposed to MySQL) and gives hints here: "Incorrect syntax near the keyword 'User'". — user166390
– user166390, Commented May 15, 2012 at 15:29
A lot of times these errors can be avoided if you use plural names for tables. Since a table is a set of something, Users is better than User unless the intention is that the table will only ever hold one row. PS I'm not suggesting that is the solution, which is why I'm posting it as a comment. — Aaron Bertrand
– Aaron Bertrand, Commented May 15, 2012 at 15:30
Also it's great that we have six identical answers to this question. Anyone feel like withdrawing their answers to remove some noise? — Aaron Bertrand
– Aaron Bertrand, Commented May 15, 2012 at 15:31

Taryn · Accepted Answer · 2012-05-15 15:24:01Z

9

User is a keyword. You will need to use an escape character. Try

SELECT * FROM [User]

answered May 15, 2012 at 15:24

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mellamokb Over a year ago

+1 You had the first answer ;)

Diego · Accepted Answer · 2012-05-15 15:25:00Z

3

User is a reserved word. You should use brackets []

SELECT * FROM [User]

answered May 15, 2012 at 15:25

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Comments

Andrey Gurinov · Accepted Answer · 2012-05-15 15:24:24Z

2

Try this:

SELECT * FROM [User];

answered May 15, 2012 at 15:24

Andrey Gurinov

2,9051 gold badge23 silver badges23 bronze badges

Comments

Barry Kaye · Accepted Answer · 2012-05-15 15:24:28Z

2

User is a reserved SQL keyword - try:

SELECT * FROM [User];

answered May 15, 2012 at 15:24

Barry Kaye

7,7696 gold badges46 silver badges65 bronze badges

Comments

Satya · Accepted Answer · 2012-05-15 15:24:30Z

2

user is a reserved keyword , can you change the tname

answered May 15, 2012 at 15:24

Satya

8,9016 gold badges41 silver badges57 bronze badges

Comments

Oded · Accepted Answer · 2012-05-15 15:24:31Z

2

"USER" is a SQL Server reserved keyword. You need to escape it:

SELECT * FROM [User];

Or:

SELECT * FROM "User";

answered May 15, 2012 at 15:24

Oded

501k102 gold badges900 silver badges1k bronze badges

Collectives™ on Stack Overflow

Query syntax error near "SELECT * FROM user"? [duplicate]

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Related