How can I check if a View exists in a Database?

sql sql-server database stored-procedures view
Draco picture Draco · Aug 20, 2009 · Viewed 180.5k times · Source

I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists?

EDIT: The DBMS being used is Microsoft SQL Server

Answer

kemiller2002 picture kemiller2002 · Aug 20, 2009

FOR SQL SERVER

IF EXISTS(select * FROM sys.views where name = '')

Related questions

Functions vs Stored Procedures

Let's say I have to implement a piece of T-SQL code that must return a table as result. I can implement a table-valued function or else a stored procedure that returns a set of rows. What should I use? In …

Read More
Invalid data type while using user defined table type

I'm new to table-valued parameter in SQL Server 2008. I tried to make user-defined table with query USE [DB_user] GO CREATE TYPE [dbo].[ApproveAddsIds] AS TABLE( [Ids] [bigint] NULL ) GO When I tried to use the table type in stored …

Read More
Stored procedure using sp_send_dbmail to send emails to multiple recipients queried from database

Like the title says, I'm trying to make a stored procedure used to send emails to addresses stored in the database, often including multiple recipients. I've tried a few approaches to this, but I think I'm hitting a wall and …

Read More