Understanding and Managing Views in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Views in SQL Server?
✍: FYIcenter.com
Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team
on Understanding and Managing Views in SQL Server.
Clear answers are provided with tutorial exercises on creating and
dropping views; defining and viewing view columns; creating views
from multiple tables; inserting, updating and deleting data in
underlying tables; creating schema binding view; creating indexes
on views.
CREATE VIEW - Creating a View on an Existing Table in SQL Server
sys.views - List of Existing Views in SQL Server
DROP VIEW - Deleting Existing Views in SQL Server
"sys.columns" - Getting a List of Columns in a View in SQL Server
"sp_columns" - Getting a List of Columns in a View in SQL Server
"sp_help" - Getting a List of Columns in a View in SQL Server
Generating CREATE VIEW Scripts on Existing Views in SQL Server
sys.sql_modules - Getting View Definitions Back in SQL Server
Creating a View with Data from Multiple Tables in SQL Server
Creating a View with Data from Another View in SQL Server
Deleting a Table That Is Used by a View in SQL Server
Using ORDER BY to Define a View in SQL Server
ALTER VIEW - Modifying Existing Views in SQL Server
Inserting Data into a View in SQL Server
Updating Data in a View in SQL Server
Deleting Data from a View in SQL Server
Assigning New Column Names in a View in SQL Server
Determining Data Types of View Columns in SQL Server
SCHEMABINDING - Binding Views to Underlying Tables in SQL Server
⇒ What Are Views in SQL Server
⇐ DROP_EXISTING - Recreating an Existing Index in SQL Server
2016-11-08, 1641🔥, 0💬
Related Topics:
