\documentclass{article}
\usepackage{xcolor}
\definecolor{bluekeywords}{rgb}{0.13,0.13,1}
\definecolor{greencomments}{rgb}{0,0.5,0}
\definecolor{redstrings}{rgb}{0.9,0,0}
\usepackage{listings}
\begin{document}
\begin{lstlisting}[language=SQL,
basicstyle=\ttfamily,
columns=fullflexible,
commentstyle=\color{greencomments},
keywordstyle=\color{bluekeywords},
stringstyle=\color{redstrings},
]
CREATE TABLE Album (
ID integer unique not null,
primary key(ID)
);
\end{lstlisting}
\end{document}