05 September 2009

🛢DBMS: Catalog View (Definitions)

"Contains metadata about objects found in a SQL Server instance." (Sara Morganand & Tobias Thernstrom , "MCITP Self-Paced Training Kit : Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 - Exam 70-442", 2007)

"A catalog view returns a SQL Server database and server-specific metadata." (Michael Coles, "Pro T-SQL 2008 Programmer's Guide", 2008)

"View that returns a SQL Server database and server-specific metadata." (Miguel Cebollero et al, "Pro T-SQL Programmer’s Guide 4th Ed", 2015)

"In DB2 for Linux, UNIX, and Windows, a SYSCAT or SYSSTAT view on the catalog table. One of a set of views automatically created when a database is created. Catalog views contain information about the database and the objects in that database. Examples of information about the database are definitions of database objects and information about the authority that users have on these objects. See also catalog table." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"Built-in views that form the system catalog for SQL Server." (Microsoft, 'SQL Server 2012 Glossary", 2012)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 25 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.