Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List View

Status
Not open for further replies.
madeline1

madeline1

Programmer
Joined
Jun 13, 2007
Messages
8
Location
US
What is the syntax to list the name of all views in SQL Server?
 
Sort by date Sort by votes
Here table_name's are the views, table_schema's are the db's.
[tt] SELECT table_name, table_schema FROM information_schema.views;[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question Question
Need to compare two tables and list the differences
Replies
3
Views
1K
EdLentz
EdLentz
Halliarse
  • Locked
  • Question Question
Search Stored Procedures, Views and Triggers
Replies
1
Views
361
Moris53
Moris53
Latoya
  • Locked
  • Question Question
Generate a report from SQL to Excel using a ListBox
Replies
1
Views
296
SkipVought
S
Shinju15
  • Locked
  • Question Question
Unknown column name' in 'field list'
Replies
1
Views
222
ChrisHirst
ChrisHirst
tyutghf
  • Locked
  • Question Question
find products not listed
Replies
11
Views
405
tyutghf
tyutghf

Part and Inventory Search

Sponsor

Back
Top