Explain system views?



Explain system views?..

Answer / Rinku Sharma

System views in SQL Server are predefined views that provide information about various aspects of the database and its objects. Examples include sys.databases, sys.tables, and sys.columns. These views can be queried to retrieve detailed information about the database's structure, statistics, and runtime information.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Which tcl commands are available on the sql server?

1 Answers  


i want table name basis on column name.

5 Answers  


Difference between server.transfer and server.execute method?

2 Answers  


What is an Index?

3 Answers   Yardi Software,


what is a deadlock? : Sql server database administration

1 Answers  


What is a NOLOCK?

3 Answers   NA,


What are the main sources of data?

1 Answers  


What is the difference between login and a user?

13 Answers   CTS, TCS,


What is Schema in Database?

1 Answers   Cap Gemini,


How to check status of stored procedure in sql server?

1 Answers  


Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,


Explain boyce and codd normal form(bcnf)?

1 Answers  


Categories