disable sql-mode autocompletion in emacs

Question

I'm trying to write my pl/sql code in following way: id_sel then hit TAB or Enter and I've got id_select completion! It works with any ...sel word. I think it is an sql-mode feature. How to disable this?

Answer 1

It's all about abbrev-mode. abbrev-mode by default uses .abbrev_defs file, that utilizes sql-mode-abbrev-table variable from sql-mode.sql.