In SQL Server Hifadhidata ya MDF na NDF, kuna meza nyingi za mfumo zinazotumika kuhifadhi muundo na data zingine za meta za hifadhidata.
Chini ni orodha ya meza za mfumo zinazotumiwa kawaida:
Jedwali la Mfumo Jina |
---|
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.synonyms |
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 |
Marejeo:
- Maoni ya Katalogi ya Kitu (Transact-SQL) ya SQL Server 2014
- Maoni ya Katalogi ya Kitu (Transact-SQL) ya SQL Server 2012
- Maoni ya Katalogi ya Kitu (Transact-SQL) ya SQL Server 2008 R2
- Maoni ya Katalogi ya Kitu (Transact-SQL) ya SQL Server 2008
- Maoni ya Katalogi ya Kitu (Transact-SQL) ya SQL Server 2005