How to use sql reserve keyword in column name

Question

How to use an SQL reserved keyword like the column name "desc" in a select statement?

select "desc" from tablename

possible duplicate of [How to deal with SQL column names that look like SQL keywords?](http://stackoverflow.com/questions/285775/how-to-deal-with-sql-column-names-that-look-like-sql-keywords) — LittleBobbyTables - Au Revoir, Oct 02 '13 at 13:27
You better consider not using reserved names as user defined object names... — Giannis Paraskevopoulos, Oct 02 '13 at 13:27
30 seconds of [Googling](https://www.google.com/search?safe=off&site=&source=hp&q=sql+how+to+use+reserved+words+in+a+statement&oq=sql+how+to+use+reserved+words+in+a+statement) would have gotten you all of these answers — LittleBobbyTables - Au Revoir, Oct 02 '13 at 13:28

score 12 · Accepted Answer · answered Oct 02 '13 at 13:23

12

Use brackets

select [desc] from tablename

answered Oct 02 '13 at 13:23

juergen d

score 0 · Answer 2 · answered Oct 05 '13 at 17:34

0

According to Standard, you can use delimited identifiers in this case, ex.

create table Tdesc("desc" int);
go
select "desc" from Tdesc order by "desc" desc;

answered Oct 05 '13 at 17:34

msi77

score 0 · Answer 3 · answered Dec 18 '19 at 17:18

0

back quotes worked for me in Hive SQL: I have a column named from, so:

select `from` from myTable;

answered Dec 18 '19 at 17:18

Igor Yagolnitser

3 Answers3