" put this in your vimrc
" code for consuming a space
func Eatchar(pat)
  let b = nr2char(getchar())
  return (b =~ a:pat) ? '' : b
endfunc

"abbreviation for primary key constraint
iab <silent> cpk CONSTRAINT <ESC>mp?CREATE TABLE<CR>2wyw`ppa_pkey PRIMARY KEY()<ESC>:silent noh<CR><ESC>A<Left><C-R>=Eatchar('\s')<CR>