Listings Keyword Can't Be Removed

Question

I have the following sample of code.

\begin{lstlisting}[
       language=SQL,
       showspaces=false,
       basicstyle=\ttfamily,
       numbers=left,
       numberstyle=\tiny,
       commentstyle=\color{gray},
       keywords={}
    ]
SELECT * FROM date;
\end{lstlisting}

Even though I have removed all keywords using keywords={}, date is still being highlighted as a keyword.

Any idea why?

Answer 1

keywords={} delete (more exactly redefine) the all keywords from keyword list 1. The DATE keyword is in the keyword list 2. So you should delete the all keywords from keyword list 2 with keywords={[2]} or keywords={[2]{}}. If you want to delete only DATE keyword, then use deletekeywords={[2]DATE}.