{"id":1167,"date":"2008-07-02T00:10:25","date_gmt":"2008-07-01T22:10:25","guid":{"rendered":"http:\/\/www.glorf.it\/blog\/?p=1167"},"modified":"2008-07-02T08:51:32","modified_gmt":"2008-07-02T06:51:32","slug":"sql-server-liste-der-internen-systemtabellen","status":"publish","type":"post","link":"http:\/\/www.glorf.it\/blog\/2008\/07\/02\/sql-talk\/sql-server\/sql-server-liste-der-internen-systemtabellen","title":{"rendered":"SQL-Server: Liste der internen Systemtabellen"},"content":{"rendered":"<p>Mit der Version 2005 hat Microsoft ja bekanntlich die Systemtabellen im SQL-Server umgebaut und versteckt. Man kommt nun eigentlich gar nicht mehr dran.<\/p>\n<p>Aber wenn man beim SQL-Server-2005 die Liste der internen Systemtabellen sehen will, dann geht das immerhin ganz einfach:<\/p>\n<p><code lang=\"sql\">SELECT      O.object_id<br \/>\n\t\t, SCHEMA_NAME(O.schema_id)<br \/>\n\t\t+&#x0027;.'+[name] AS &quot;internal system table&quot;<br \/>\n\tFROM sys.objects AS O<br \/>\n\tWHERE O.type=N&#x0027;S&#x0027;<br \/>\n\tORDER BY O.object_id;<\/code><\/p>\n<p>Und so sieht das Ergebnis aus:<br \/>\n<!--more--><\/p>\n<table class=\"sqltable\">\n<tr>\n<th>object_id<\/th>\n<th>internal system table<\/th>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>sys.sysrowsetcolumns<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>sys.sysrowsets<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>sys.sysallocunits<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>sys.sysfiles1<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>sys.syshobtcolumns<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>sys.syshobts<\/td>\n<\/tr>\n<tr>\n<td>25<\/td>\n<td>sys.sysftinds<\/td>\n<\/tr>\n<tr>\n<td>26<\/td>\n<td>sys.sysserefs<\/td>\n<\/tr>\n<tr>\n<td>27<\/td>\n<td>sys.sysowners<\/td>\n<\/tr>\n<tr>\n<td>28<\/td>\n<td>sys.sysdbreg<\/td>\n<\/tr>\n<tr>\n<td>29<\/td>\n<td>sys.sysprivs<\/td>\n<\/tr>\n<tr>\n<td>34<\/td>\n<td>sys.sysschobjs<\/td>\n<\/tr>\n<tr>\n<td>39<\/td>\n<td>sys.syslogshippers<\/td>\n<\/tr>\n<tr>\n<td>41<\/td>\n<td>sys.syscolpars<\/td>\n<\/tr>\n<tr>\n<td>42<\/td>\n<td>sys.sysxlgns<\/td>\n<\/tr>\n<tr>\n<td>43<\/td>\n<td>sys.sysxsrvs<\/td>\n<\/tr>\n<tr>\n<td>44<\/td>\n<td>sys.sysnsobjs<\/td>\n<\/tr>\n<tr>\n<td>45<\/td>\n<td>sys.sysusermsgs<\/td>\n<\/tr>\n<tr>\n<td>46<\/td>\n<td>sys.syscerts<\/td>\n<\/tr>\n<tr>\n<td>47<\/td>\n<td>sys.sysrmtlgns<\/td>\n<\/tr>\n<tr>\n<td>48<\/td>\n<td>sys.syslnklgns<\/td>\n<\/tr>\n<tr>\n<td>49<\/td>\n<td>sys.sysxprops<\/td>\n<\/tr>\n<tr>\n<td>50<\/td>\n<td>sys.sysscalartypes<\/td>\n<\/tr>\n<tr>\n<td>51<\/td>\n<td>sys.systypedsubobjs<\/td>\n<\/tr>\n<tr>\n<td>54<\/td>\n<td>sys.sysidxstats<\/td>\n<\/tr>\n<tr>\n<td>55<\/td>\n<td>sys.sysiscols<\/td>\n<\/tr>\n<tr>\n<td>56<\/td>\n<td>sys.sysendpts<\/td>\n<\/tr>\n<tr>\n<td>57<\/td>\n<td>sys.syswebmethods<\/td>\n<\/tr>\n<tr>\n<td>58<\/td>\n<td>sys.sysbinobjs<\/td>\n<\/tr>\n<tr>\n<td>60<\/td>\n<td>sys.sysobjvalues<\/td>\n<\/tr>\n<tr>\n<td>64<\/td>\n<td>sys.sysclsobjs<\/td>\n<\/tr>\n<tr>\n<td>65<\/td>\n<td>sys.sysrowsetrefs<\/td>\n<\/tr>\n<tr>\n<td>67<\/td>\n<td>sys.sysremsvcbinds<\/td>\n<\/tr>\n<tr>\n<td>68<\/td>\n<td>sys.sysxmitqueue<\/td>\n<\/tr>\n<tr>\n<td>69<\/td>\n<td>sys.sysrts<\/td>\n<\/tr>\n<tr>\n<td>71<\/td>\n<td>sys.sysconvgroup<\/td>\n<\/tr>\n<tr>\n<td>72<\/td>\n<td>sys.sysdesend<\/td>\n<\/tr>\n<tr>\n<td>73<\/td>\n<td>sys.sysdercv<\/td>\n<\/tr>\n<tr>\n<td>74<\/td>\n<td>sys.syssingleobjrefs<\/td>\n<\/tr>\n<tr>\n<td>75<\/td>\n<td>sys.sysmultiobjrefs<\/td>\n<\/tr>\n<tr>\n<td>76<\/td>\n<td>sys.sysdbfiles<\/td>\n<\/tr>\n<tr>\n<td>78<\/td>\n<td>sys.sysguidrefs<\/td>\n<\/tr>\n<tr>\n<td>80<\/td>\n<td>sys.syschildinsts<\/td>\n<\/tr>\n<tr>\n<td>90<\/td>\n<td>sys.sysqnames<\/td>\n<\/tr>\n<tr>\n<td>91<\/td>\n<td>sys.sysxmlcomponent<\/td>\n<\/tr>\n<tr>\n<td>92<\/td>\n<td>sys.sysxmlfacet<\/td>\n<\/tr>\n<tr>\n<td>93<\/td>\n<td>sys.sysxmlplacement<\/td>\n<\/tr>\n<tr>\n<td>94<\/td>\n<td>sys.sysobjkeycrypts<\/td>\n<\/tr>\n<tr>\n<td>95<\/td>\n<td>sys.sysasymkeys<\/td>\n<\/tr>\n<tr>\n<td>96<\/td>\n<td>sys.syssqlguides<\/td>\n<\/tr>\n<tr>\n<td>97<\/td>\n<td>sys.sysbinsubobjs<\/td>\n<\/tr>\n<\/table>\n<p>Und was man damit machen kann, <a href=\"http:\/\/www.glorf.it\/blog\/2008\/06\/29\/sql-server\/sql-server-auf-interne-system-tabellen-direkt-zugreifen\">beschrieb ich neulich<\/a> ja schon&#8230; \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mit der Version 2005 hat Microsoft ja bekanntlich die Systemtabellen im SQL-Server umgebaut und versteckt. Man kommt nun eigentlich gar nicht mehr dran. Aber wenn man beim SQL-Server-2005 die Liste der internen Systemtabellen sehen will, dann geht das immerhin ganz einfach: SELECT O.object_id , SCHEMA_NAME(O.schema_id) +&#x0027;.&#x0027;+[name] AS &quot;internal system table&quot; FROM sys.objects AS O WHERE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[929,182],"_links":{"self":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/1167"}],"collection":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/comments?post=1167"}],"version-history":[{"count":0,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/1167\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/media?parent=1167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/categories?post=1167"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/tags?post=1167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}