>Hi,
>Can I create a view (dynamically) from C# code? Here is a simple example:
>DB has a table Equipment with the following columns:
>Eq_ID Char(15)
>Eq_Desc Char(40)
>IncInView Bit
>
>I need to make a call from C# (ASP.NET) and create a view that will have the following:
>Eq_ID
>Eq_Desc
>Only those rows that have InInView set to 1
>And name this view, for example, EQ_2015_02_17
>
>Ideally I would like this view to "auto destroy" the next day.
>
>TIA for any help.


Hi, Dmitry,

A question - are you looking to create a SQL view itself, or an extract of daily data? I think there might be some confusion on nomenclature (or maybe the confusion is mine)