How do I locate data in my SQL Server tables using SQL Server Management Studio diagrams?

Locate data quickly and easily with the SQL Server Management Studio diagram tool.

By Mark Long
February 22, 2017
Screen from "How do I locate data in my SQL Server tables using SQL Server Management Studio diagrams?" Screen from "How do I locate data in my SQL Server tables using SQL Server Management Studio diagrams?" (source: O'Reilly)

Constructing a Transact-SQL query is only part of the process – you must also know where to find the data required by your query. In this video, Mark Long teaches you how to use the diagram tool built into SQL Server Management Studio to locate your data easily and efficiently. Transact-SQL programmers with basic query skills and familiarity with the SQL Server Management Studio will be able to locate data in unfamiliar databases, identify all directly related tables, and respond to data requests more efficiently.

Access in-depth Transact-SQL training with the Querying Data with Transact-SQL – Exam 70-761 Certification Training Course.

Learn faster. Dig deeper. See farther.

Join the O'Reilly online learning platform. Get a free trial today and find answers on the fly, or master something new and useful.

Learn more

A 25-year veteran of the information technology field, Mark Long witnessed the birth and adoption of the Local Area Network. In 1996, equipped a long list of industry certifications, Mark launched his own consulting, development, and training company. Mark has tackled a wide range of technological challenges for sole-proprietor startups, Fortune 100 companies, the Texas State Legislature, U.S. Air Force, and companies in the entertainment industry.

Post topics: Software Engineering
Share: