Take the 2-minute tour ×  How can i see only VIEWS in SQLite.
.tables command list both views as well as tables. I want to see
only VIEWS and not tables.   share|improve this question add
comment  1 Answer  up vote 1 down vote accepted  You can do:
SELECT sql FROM sqlite_master WHERE type = 'view';  In order to
fine-tune it:  .headers on select * from sqlite_master;  you
will know what columns are available there.  share|improve this
answer thanks. its perfect! –  Saumitra Feb 28 '12 at 9:56 add
comment  Your Answer