Metadata

SQL Server Metadata Functions: The Basics

  • Article

To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.

2016-03-28

6,652 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Concat XML field values ?

By jbalbo

Hi I have the XML field  below I need to concatenate the "Purpose of...

convert string + add '.'

By samirca007

Hello Please help me (how to modify a character string in sql server 2017)...

How to populate Temp table from Stored Procedure

By rkordonsky 63916

I am trying to put the result of Stored Procedure execution into Temp Table:...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers