METADATA

Question

I need links of websites about key word "SYS" for exeample sys.tables, sysprocedures, sys.sysdatabases, etc...

I have websites tha explain every about "SYS"

Can we help me?

---

rodrigobrs111

Answer 1

There are a number of sources, for example from Microsoft documentation...

http://msdn.microsoft.com/en-us/library/ms189082(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms345522.aspx#_FAQ31

...and blog articles like...

http://thomaslarock.com/2011/03/march-madness-sql-server-system-tables-sysdatabases/

...also there is the following poster showing the SQL Server 2008 metadata views and their relationships which is very useful, especially as a starting point to research further...

http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c

Thanks

---

/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem