Video:
Why You Need to Refresh Your Views After Adding Columns to a Table, Part 2
-
Skill level:
300 (Intermediate)
-
Run Time:
07:45
-
Instructor:
Scott Whigham
Description:
So what actually happens when we create a view in SQL Server? In this second video in the series, Scott will show you two queries you can use to find the differences in your table vs. view as well as demonstrate three techniques used to refresh the metadata of the view
Highlights from this video:
- About system views and catalog views
- Using the information_schema query to identify where the views differ from the tables
- Using sys.columns to identify where the views differ from the tables
- Three techniques for refreshing metadata of a view
- Scott's suggested technique
and much more
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
|
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
|
200
|
Download
|
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
|
300
|
Download
|
|
Creating Database Diagrams in SQL Server Management Studio
|
200
|
Download
|
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
|
300
|
Download
|
|
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)
|
200
|
Download
|
NOTE: This video is part of our
SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter
12:
Views in SQL Server
Jump to a specific chapter: