Question

select view(which view)

Answer 1

Do you mean SQL views? Or something else (a UI “view”, BI report, etc.)? Tell me which database or system you’re using and whether you want to:
- run a SELECT against a view,
- list available views,
- see a view’s definition,
- create or drop a view,
or something else.

Quick reference for common databases:

1) Query a view (generic)
- SELECT * FROM schema.view_name WHERE ...;

2) List views
- PostgreSQL / MySQL (information_schema):
- SELECT table_name FROM information_schema.views WHERE table_schema = 'public';
- SQL Server:
- SELECT name FROM sys.views;
- or SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA='dbo';
- Oracle:
- SELECT view_name FROM user_views;
- SQLite:
- SELECT name FROM sqlite_master WHERE type='view';

3) See view definition
- PostgreSQL:
- SELECT definition FROM pg_views WHERE schemaname='public' AND viewname='my_view';
- or SELECT pg_get_viewdef('public.my_view'::regclass, true);
- MySQL:
- SHOW CREATE VIEW my_view;
- SQL Server:
- EXEC sp_helptext 'schema.my_view';
- or SELECT OBJECT_DEFINITION(OBJECT_ID('schema.my_view'));
- Oracle:
- SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME='MY_VIEW';
- SQLite:
- SELECT sql FROM sqlite_master WHERE type='view' AND name='my_view';

4) Create / drop a view
- CREATE VIEW schema.my_view AS SELECT col1, col2 FROM table WHERE ...;
- DROP VIEW schema.my_view;

Give me your DB type and what you want to do and I’ll give the exact command or example.