#sys.columns

[essentialsql]

Learn to use the data dictionary in SQL Server

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 key defined?

By reading this article you’ll learn to query the data dictionary, but before…

View On WordPress