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.
Also read
SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns,
just like a real table..............
Catalog views can be used to return information like objects, logins permissions
etc used by SQL server database engine...............
Partitioned view joins the horizontally portioned data. This data may belong to
one ore more servers.............
Answer - Views can be created referencing tables and views only
in the current database.......
Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.
|
