Data Dictionary Tag Archives

Learn to use the Data Dictionary in SQL Server

In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.  Knowing how to query the data dictionary is good to know.  There are many questions you can answer about your database through the data dictionary. For instance, do you know how many of your table don’t have a primary […]

Continue reading

What is a SQL Server Data Dictionary?

Data Dictionary - Cards

What is a Data Dictionary? In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition.  The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views. The data dictionary is used by SQL server to execute queries and is automatically updated […]

Continue reading