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

The 99 Flavours of SQL Server are all Vanilla

By

There are so many options for running SQL Server now. It can feel a...

Why do DBAs dislike loops?

By

If you started out as a developer you were probably taught how important loops...

Public and Demo Data Coming Soon!

By

Any database professional that has been around the Microsoft world for more than about...

Read the latest Blogs

Forums

Waits and Queues

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Waits and Queues

Synonyms for Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synonyms for Tables

install problem Missing >> Select a configuration task panel

By Digs

I have both MS SQL 2008 R2 and MS SQL 2014 (both developer editions)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers