· 7 years ago · Oct 29, 2018, 08:52 PM
1CREATE view MyView
2AS
3
4IF OBJECT_ID (N'dbo.MyTable', N'U') IS NOT NULL
5 SELECT TOP 1 TheColumn
6 FROM dbo.MyTable
7 ELSE SELECT cast(NULL as nvarchar(max)) as TheColumn
8
9GO
10
11-- from SQL Server 2016 and above you can use
12DROP TABLE IF EXISTS Table_Name;