What is Catalog Views? Its purposes

          

Interview questions

SQL Server - What is Catalog Views?

Next>>         SQL Server tutorial  

SQL Server - What is Catalog Views? Its purposes - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

What is Catalog Views? Its purposes

Catalog views return information used by the SQL Server. They are the most general interface to the catalog metadata and provide efficient way to obtain, transform and present custom forms of this information. They however, do not contain information about replication, backup or maintenance plans etc.

Purpose to use catalog views:

  • Access to metadata of databases
  • Most efficient way to access server metadata
  • Catalog view names and column names are descriptive, which enables a user to query what is expected without having extreme knowledge corresponding to metadata.

SQL Server - What is Catalog Views? Its purposes - May 05, 2009 at 22:00 PM by Rajmeet Ghai

What is Catalog Views? Its purposes

Catalog views can be used to return information like objects, logins permissions etc used by SQL server database engine. Rather than accessing the system tables directly, catalog views can be used. Catalog views don’t contain information about replication backup etc. The catalog views are not affected by change in any underlying tables.

SQL Server - What is Catalog Views? - May 19, 2009 at 10:30 AM by Rajmeet Ghai

What is Catalog Views?

Catalog views serve as a repository to store static metadara like server side and database specific objects. This includes logins, tables, stored procedures etc. It is always better to use catalogue views to view system data rather than using system tables.

SQL Server - What is Catalog Views? - June 21, 2009 at 09:30 AM by Amit Satpute

The system catalog tables are maintained automatically by the UDB system. The catalog tables are stored in the SYSIBM schema. However, these table names do not follow any naming convention.

The catalog views that have been defined over these tables provide consistency with their naming due to which they should be used to interact with the tables.

One of the catalog views set that is defined in SYSCAT can be only read and not be updated and the other which is defined in SYSSTAT is meant for authorized users to update statistics used for query optimization manually.

Next>>

Also read

SQL CREATE VIEW

SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns, just like a real table..............

What is Catalog Views?

Catalog views can be used to return information like objects, logins permissions etc used by SQL server database engine...............

Explain the concepts and capabilities of partitioned views.

Partitioned view joins the horizontally portioned data. This data may belong to one ore more servers.............

What are the restrictions applicable while creating views?

Answer - Views can be created referencing tables and views only in the current database.......

Sql Server database maintenance

Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring