Anil Singh | Code-sample.com

Hello everyone, I am going to share the code sample for check a View is exists or not in SQL Server . The different type of system objects are use to check SQL view is exists or not . The Types are 1.        SYS . VIEWS 2.        SYS . OBJECTS 3.        SYS . SQL_MODULES 4.        SYS . SYSOBJECTS Syntax for check SQL View exists using SYS . VIEWS IF EXISTS( SELECT 1 FROM SYS . VIEWS WHERE Name = 'VP_VIEW_CEU' )     BEGIN         PRINT 'View Is Exist!'     END ELSE PRINT 'View Not Exist!' Syntax for check SQL View exists using SYS . OBJECTS IF EXISTS ( SELECT * FROM SYS . OBJECTS             WHERE object_id = OBJECT_ID ( 'dbo.VP_VIEW_CEU' ))     BEGIN         PRINT 'View Is Exist!'     END ELSE PRINT 'View Is Not Exist!' Syntax for check SQL View exists using SYS . SQL_MODULES IF EXISTS ( SELECT 1 FROM SYS . SQL_MODULES               WHERE object