Title here
Summary here
Creates or alters a view.
public sealed class CreateViewTask : ControlFlowTask, ILoggableTask
CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");
public CreateViewTask()
public CreateViewTask(string viewName, string definition)
Type | Name | Description |
---|---|---|
string | viewName | |
string | definition |
The view definition.
public string Definition { get; set; }
Type | Description |
---|---|
string |
The sql that is generated to create the view
public string Sql { get; }
Type | Description |
---|---|
string |
The formatted name of the view
public ObjectNameDescriptor VN { get; }
Type | Description |
---|---|
ObjectNameDescriptor |
Optional, will set the view attributes, e.g. "WITH SCHEMABINDING". This part is put after the CREATE VIEW [viewname] statement and before the AS statement.
public string ViewAttributes { get; set; }
Type | Description |
---|---|
string |
The name of the view
public string ViewName { get; set; }
Type | Description |
---|---|
string |
Creates or alter a view.
public static void CreateOrAlter(IConnectionManager connectionManager, string viewName, string definition)
Type | Name | Description |
---|---|---|
IConnectionManager | connectionManager | The connection manager of the database you want to connect |
string | viewName | The name of the view |
string | definition | The view definition |
Creates or alter a view.
public static void CreateOrAlter(string viewName, string definition)
Type | Name | Description |
---|---|---|
string | viewName | The name of the view |
string | definition | The view definition |