Systemtabellen in SQL Server MDF- und NDF-Datenbanken

In SQL Server In MDF- und NDF-Datenbanken gibt es viele Systemtabellen, in denen Struktur- und andere Metadaten der Datenbanken gespeichert werden.

Unten finden Sie eine Liste der häufig verwendeten Systemtabellen:

Name der Systemtabelle

sys.allocation_units

sys.objects

sys.assembly_modules

sys.parameter

sys.check_constraints

sys.partitionen

sys.spalten

sys.prozeduren

sys.computed_columns

sys.sequenzen

sys.default_constraints

sys.service_queues

sys.events

sys.sql_dependencies

sys.event_notifications

sys.sql_expression_dependencies

sys.extended_procedures

sys.sql_modules

sys.foreign_key_columns

sys.stats

sys.foreign_keys

sys.stats_columns

sys.function_order_columns

sys.synonyme

sys.hash_indexes

sys.table_types

sys.identity_columns

sys.tabellen

sys.index_columns

sys.trigger_event_types

sys.indexes

sys.trigger_events

sys.key_constraints

sys.triggers

sys.numbered_procedure_parameters

sys.views

sys.numbered_procedures

References: XNUMX: Tiley, G.E.D., XNUMX: Biological Flora of the British Isles. Cirsium arvense (L.) Scop. Journal of Ecology XNUMX, XNUMX-XNUMX. XNUMX: Moore, RJ. (XNUMX). The biology of Canadian weeds.XNUMX. Cirsium arvense (L.) Scop. Canada Journal of Plant science, XNUMX:XNUMX-XNUMX. XNUMX: Leth, V.,Netland, J.& Andreasen C. (XNUMX). Phomopsis cirsii: a potential biocontrol agent of Cirsium arvense. Weed Research, XNUMX:XNUMX-XNUMX. XNUMX: Nadeau, L.B. & Vanden Born, W.H. (XNUMX). The root system of Canada thistle. Canadian Journal of Plant Science, XNUMX: XNUMX-XNUMX. XNUMX: Tiley, G.E.D., XNUMX: Biological Flora of the British Isles. Cirsium arvense (L.) Scop. Journal of Ecology XNUMX, XNUMX-XNUMX. XNUMX: Tworkoski, T. (XNUMX). Developmental and environmental effects on assimilate partitioning in Canada thistle (Cirsium arvense). Weed Science XNUMX:XNUMX-XNUMX. XNUMX: Hettwer, U., B. Gerowitt, XNUMX: An investigation of genetic variation in Cirsium arvense field patches. Weed Research XNUMX, XNUMX-XNUMX. XNUMX: Dau, A., XNUMX: Cirsium arvense (L.) Scop in arable farming: Vegetative and generative reproduction as influenced by agronomic measures. PhD-thesis, University of Rostock. XNUMX: Hakansson, S. (XNUMX). Weeds and Weed Management on Arable Land: An Ecological Approach, CAB International, Wallingford, UK.