Struct CreateView 

pub struct CreateView {

    pub or_alter: bool,
    pub or_replace: bool,
    pub materialized: bool,
    pub secure: bool,
    pub name: ObjectName,
    pub name_before_not_exists: bool,
    pub columns: Vec<ViewColumnDef>,
    pub query: Box<Query>,
    pub options: CreateTableOptions,
    pub cluster_by: Vec<Ident>,
    pub comment: Option<String>,
    pub with_no_schema_binding: bool,
    pub if_not_exists: bool,
    pub temporary: bool,
    pub to: Option<ObjectName>,
    pub params: Option<CreateViewParams>,
}

CREATE VIEW statement.

Fields

or_alter: bool

True if this is a CREATE OR ALTER VIEW statement

MsSql

or_replace: bool

The OR REPLACE clause is used to re-create the view if it already exists.

materialized: bool

if true, has MATERIALIZED view modifier

secure: bool

Snowflake: SECURE view modifier https://docs.snowflake.com/en/sql-reference/sql/create-view#syntax

name: ObjectName

View name

name_before_not_exists: bool

If if_not_exists is true, this flag is set to true if the view name comes before the IF NOT EXISTS clause. Example:

CREATE VIEW myview IF NOT EXISTS AS SELECT 1`

Otherwise, the flag is set to false if the view name comes after the clause Example:

CREATE VIEW IF NOT EXISTS myview AS SELECT 1`

columns: Vec<ViewColumnDef>

Optional column definitions

query: Box<Query>

The query that defines the view.

options: CreateTableOptions

Table options (e.g., WITH (..), OPTIONS (…))

cluster_by: Vec<Ident>

BigQuery: CLUSTER BY columns

comment: Option<String>

Snowflake: Views can have comments in Snowflake. https://docs.snowflake.com/en/sql-reference/sql/create-view#syntax

with_no_schema_binding: bool

if true, has RedShift [WITH NO SCHEMA BINDING] clause https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_VIEW.html

if_not_exists: bool

if true, has SQLite IF NOT EXISTS clause https://www.sqlite.org/lang_createview.html

temporary: bool

if true, has SQLite TEMP or TEMPORARY clause https://www.sqlite.org/lang_createview.html

to: Option<ObjectName>

if not None, has Clickhouse TO clause, specify the table into which to insert results https://clickhouse.com/docs/en/sql-reference/statements/create/view#materialized-view

params: Option<CreateViewParams>

MySQL: Optional parameters for the view algorithm, definer, and security context

Trait Implementations

impl Clone for CreateView

fn clone(&self) -> CreateView

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for CreateView

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for CreateView

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<CreateView> for Statement

fn from(cv: CreateView) -> Self

Converts to this type from the input type.

impl Hash for CreateView

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for CreateView

fn cmp(&self, other: &CreateView) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for CreateView

fn eq(&self, other: &CreateView) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for CreateView

fn partial_cmp(&self, other: &CreateView) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for CreateView

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl Visit for CreateView

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

Visit this node with the provided Visitor.

impl VisitMut for CreateView

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

Mutably visit this node with the provided VisitorMut.

impl Eq for CreateView

impl StructuralPartialEq for CreateView