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.parameters |
sys.check_constraints |
sys.partitions |
sys.columns |
sys.procedures |
sys.computed_columns |
sys.sequences |
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.tables |
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.
- Objektkatalogansichten (Transact-SQL) für SQL Server 2014
- Objektkatalogansichten (Transact-SQL) für SQL Server 2012
- Objektkatalogansichten (Transact-SQL) für SQL Server 2008 R2
- Objektkatalogansichten (Transact-SQL) für SQL Server 2008
- Objektkatalogansichten (Transact-SQL) für SQL Server 2005