SQL Server Transact Basic to Expert - Query to refresh a View Definition

Karthikeyan Anbarasan
13y
2.8k
0
0

Blog

This blog show how to query and refresh a view definition using the query analyer

Syntax:
Exec sp_refreshview 'Schema.ViewName'

Example:

EXEC sp_refreshview 'dbo.vemptable'

SQL Server Transact Basic to Expert - Query to refresh a View Definition

Up Next

SQL Server Transact Basic to Expert - Create basic View with Encryption

Ebook Download

View all

Basics of SQL Server

Read by 1.5k people

Download Now!

Learn

View all