Getting useful Metadata from SQL Server

• ktflash

  Default port

  Points: 1400

  More actions

  May 15, 2019 at 9:49 am

  #3642272

  Ahoi,

  currently the only metadata i am retrieving from the SQL Server from time to time is by querying from:

  select *
  from INFORMATION_SCHEMA

  My question is:

  How do i get into retrieving and learning about Sys Tables, Sys Objects, ....

  Is there some some book suggestion or something similiar where i can get into this topic?

  For someone who has not worked with this yet it seems like a topic that is so huge that i dont know where to start/not sure what so search for to find something useful.

   

   

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• Eric M Russell

  SSC Guru

  Points: 125561

  More actions

  May 15, 2019 at 1:09 pm

  #3642340

  Microsoft's MSDN website has good documentation, and there are a couple of books by RedGate that might be useful.

  Here are a few that I've bookmarked in the past to get you started.

  https://www.snowflake.com/wp-content/uploads/Info-Schema-with-Descriptions.pdf

  https://assets.red-gate.com/community/books/performance-tuning-with-dmvs.pdf

  SQL Server 2012 System Views Map

  https://www.microsoft.com/en-us/download/details.aspx?id=39083

  https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql?view=sql-server-2017

  • This reply was modified 5 years, 6 months ago by  Eric M Russell.

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

• ktflash

  Default port

  Points: 1400

  More actions

  May 21, 2019 at 8:51 am

  #3645624

  Thanks, will take a look into this

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help