TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Parminder Pal Singh
NA
370
351.7k
How to list all the System Views?
Aug 2 2017 4:00 AM
Hi,
I hope you all are doing well. Today i came with new challenge. The matter included in this form is just for the knowledge purpose, so following is the thing what i am looking for.
As We have metadata of all objects inside the System Views of Views like sys.tables, sys.all_objects, sys.columns etc. I don't want to go with any user interface, just want to list all the things with a query.
How can i list all the System Views
?
or
I need a query that can list all the System Views
,
e.g
output should be like that:
query:
SELECT * FROM [dbo].[abc]
Result:
-- Name --
1) sys.tables
2) sys.columns
3) sys.views
4) information_schema.schemata
......
N) upto so on....
Reply
Answers (
7
)
Account is currently locked out issue
count values using sql query