[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 92
  • Last Modified:

SQL layouts

As a developer, what is a good way to learning database tables layouts? There are multiple db, tables and views. What should I focus on first?
3 Solutions
choose one db at a time
investigate those tables
then look at the views

is this what you are looking for?
ps: I'm not sure what you mean by "layout"

+edit: what tools do you have to access the dbs?
VBdotnet2005Author Commented:
I just started my new job. There are many tables, views and store procedures. I just a need good good way to approach them.
VBdotnet2005Author Commented:
I am using Microsoft SQL Server Management Studio for 2008r2
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Diagrams are often a nice way to start with unfamiliar dbs.
Perhaps there are already some diagrams - ask your co-workers

Try looking at this youtube vid (esp. the beginning 2.5 minutes or so)
I like to start with the views.  It'll give you a few ideas on how tables are joined.  Identify which tables require a foreign key from other tables.  Reports are a good source for this as well.  *Hopefully* there is some sort of consistent naming convention.  Also, look at any code that accesses the database (either stored procedures or client-side code).  The goal is try to identify the relationships, not just what data is where (that'll come to automatically later).  Use 'EXEC sp_help <object_name>' a LOT.  (EXEC sp_helptext 'proc_name' for stored procedures).
David ToddSenior DBACommented:

If in a MS shop, grab a copy of Viso and create a diagram or two per database and print it out. Viso can "reverse engineer" a database and show the relation between tables based on the foreign key attributes etc.

Once you get that then take a look at a small sample of whats in the table. ie select top 100 * from dbo.sometable order by newid()


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now