Searching for a view or any object in SQL Server?

Question

I need to find a view in SQL Server 2000, 2005 and 2008. Actually, I'd like to be able to find anything using a simple query. I tried one answer which did not work - How can I check if a View exists in a Database?

Is there a script to search for views or any other object that is guaranteed to work in all SQL Server versions I mentioned? I prefer something which does not need you to know table names and such to find a view.

If you are using SQL Server Management Studio you can simple press F6 and use the searching engine. — gotqn
– gotqn, Commented Nov 20, 2013 at 19:01
@gotqn - What does F6 do ? If I know, I can manually go to that menu. f6 does nothing for me. — Trojan.ZBOT
– Trojan.ZBOT, Commented Nov 20, 2013 at 19:04
It should open your Object Explorer - technet.microsoft.com/en-us/library/ms174205.aspx and using it you can search for your view - technet.microsoft.com/en-us/library/ms173849.aspx — gotqn
– gotqn, Commented Nov 20, 2013 at 19:27

lopushen · Accepted Answer · 2013-11-20 19:02:43Z

3

you may need this query

SELECT TABLE_NAME as ViewName,
VIEW_DEFINITION as ViewDefinition
FROM INFORMATION_SCHEMA.Views

answered Nov 20, 2013 at 19:02

lopushen

1,1472 gold badges11 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Smith · Accepted Answer · 2013-11-20 19:01:48Z

1

If you need SQL Server 2000 compatibility (so sys.views is not available) you can query INFORMATION_SCHEMA.VIEWS

For other types of objects the SQL Server 2000 view sysobjects is still available in later versions for backward compatibility reasons.

answered Nov 20, 2013 at 19:01

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Collectives™ on Stack Overflow

Searching for a view or any object in SQL Server?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related