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

Daily Coping 13 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – August 2020 – More DML Triggers

By

Well, I’m running a bit late. Both for this month and the fact I...

Your First Databricks Notebook

By

On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

BDC Orchestration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BDC Orchestration

Subquery in WHERE clause not working

By amy.holzinger

Hi everyone:  This is in SQL 2016.  The following query is returning no results:...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers