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 21 Sep 2021

By

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

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Difference between SaaS and web application?

By milowbrac

I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...

Reducing Temp Table Scans when joining two temp tables using OR conditions

By scarr030

Hi all. I have also posted this on DBA Stack Exchange, but I'm posting...

question about username dbo

By cphite

I have been asked to revoke access from a few developers in SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers