Query to find all views attached to table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Query to find all views attached to table

Author

Topic

Dinky
Starting Member

37 Posts

Posted - 2008-01-29 : 16:44:30

How to query to find out all views attached to a particular table.

Thanks

tprupsis
Yak Posting Veteran

88 Posts

Posted - 2008-01-29 : 16:49:49

select * from information_schema.view_table_usage
where table_name = 'TableName'

Tom Rupsis
Granite Peak Systems
Phone: 406-672-8292
Email: trupsis@granitepeaksys.com
LinkedIn: www.linkedin.com/in/trupsis

Dinky
Starting Member

37 Posts

Posted - 2008-01-29 : 17:23:15

perfect. Thanks tprupsis.

-Dinky

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources