sys.pdw_materialized_view_mappings (Transact-SQL)sys.pdw_materialized_view_mappings (Transact-SQL)

S’applique à :Applies to: ouiAzure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse AnalyticsS’applique à :Applies to: ouiAzure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

Lie la vue matérialisée aux noms d’objets internes en object_id.Ties the materialized view to internal object names by object_id.

Les colonnes physical_name et object_id forment la clé de cet affichage catalogue.The columns physical_name and object_id form the key for this catalog view.

Nom de la colonneColumn Name Type de donnéesData Type DescriptionDescription
physical_namephysical_name nvarchar (36)nvarchar(36) Nom physique de la vue matérialisée.The physical name for the materialized view.
object_idobject_id intint ID d’objet de la vue matérialisée.The object ID for the materialized view. Consultez sys. Objects (Transact-SQL).See sys.objects (Transact-SQL).

AutorisationsPermissions

Requiert l'autorisation VIEW DATABASE STATE.Requires VIEW DATABASE STATE permission.

Voir aussiSee also

Réglage des performances avec une vue matérialisée Performance tuning with Materialized View
CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL) CREATE MATERIALIZED VIEW AS SELECT (Transact-SQL)
ALTER MATERIALIZED VIEW (Transact-SQL) ALTER MATERIALIZED VIEW (Transact-SQL)
EXPLAIN (Transact-SQL) EXPLAIN (Transact-SQL)
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL) sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL) sys.pdw_materialized_view_distribution_properties (Transact-SQL)
DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL) DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)
Vues de catalogue Azure Synapse Analytics et Parallel Data Warehouse Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
Vues système prises en charge dans Azure Synapse Analytics System views supported in Azure Synapse Analytics
Instructions T-SQL prises en charge dans Azure Synapse AnalyticsT-SQL statements supported in Azure Synapse Analytics