quote:

---

Originally posted by BATTY_1

Hi. Hope someone can help.

I am trying to create a view that makes sure if one of two or both columns exists in a table then include it in the view. I have used add new view in my sql database as the starting point.

Here is my script that does not check for the columns

select METAID, A46 AS Surname, A36 as PolicyNumber
From dbo.TU22_ATTRIBUTE
union
select METAID, A46 AS Surname, A36 as PolicyNumber
From dbo.TU23_ATTRIBUTE

What I would like to do is check if A46 or A36 or both exist then include it in the view, if not just ignore it.

Thanks in Advance

---

quote:

---

Originally posted by nigelrivett

A view is static. It can't be conditional on the existence of a column.
You can generate the view and make that creation conditional.


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

IF EXISTS( SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'your view name' AND TABLE_SCHEMA = 'Your schema name' AND TABLE_TYPE = 'View')
  DROP VIEW youviewname
GO
CREATE VIEW youviewname
AS
...