Sign in
Vipul Shah's SQL Blogs
SQL Server Blogs
Tags
/3GB /PAE and AWE
64-bit
Benefits of SQL 2005
Bing
Bing Map Apps
Bing Maps
Data Scripter Utility
Database Design
DDL Triggers
Default Traces
DTS
Guest User in SQL Server
Indexes
Integration Services
LOGON Triggers
Migration to SQL 2005
Missing Indexes DMVs
Monitoring
Patches
Reporting Services
SQL Server Management Studio
SQL Server Performance
Table Partitioning
T-SQL
Browse by Tags
TechNet Blogs
>
Vipul Shah's SQL Blogs
>
All Tags
>
t-sql
Tagged Content List
Blog Post:
How to parse the view definition and get the base tables and base columns information
VipulShah
You can use INFORMATION_SCHEMA.VIEW_TABLE_USAGE and INFORMATION_SCHEMA.VIEW_COLUMN_USAGE from SQL70 onwards. And you can use sys.sql_dependencies in SQL Server 2005.
on
6 Mar 2007
Page 1 of 1 (1 items)