Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
How to list all the System Views?
Parminder Pal Singh
Aug 2 2017 4:00 AM
268
Reply
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....
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Account is currently locked out issue
count values using sql query