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


