Method SQL

pkg/sql/ast/sql.go:987–1017

SQL returns the full SQL string for this CREATE VIEW statement including the optional OR REPLACE, TEMPORARY, IF NOT EXISTS, column list, SELECT query, and WITH CHECK OPTION clause.

()

// optional OR REPLACE, TEMPORARY, IF NOT EXISTS, column list, SELECT query,
// and WITH CHECK OPTION clause.
func (c *CreateViewStatement) SQL() string {
	if c == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("CREATE ")
	if c.OrReplace {
		sb.WriteString("OR REPLACE ")
	}
	if c.Temporary {
		sb.WriteString("TEMPORARY ")
	}
	sb.WriteString("VIEW ")
	if c.IfNotExists {
		sb.WriteString("IF NOT EXISTS ")
	}
	sb.WriteString(c.Name)
	if len(c.Columns) > 0 {
		sb.WriteString(" (")
		sb.WriteString(strings.Join(c.Columns, ", "))
		sb.WriteString(")")
	}
	sb.WriteString(" AS ")
	sb.WriteString(stmtSQL(c.Query))
	if c.WithOption != "" {
		sb.WriteString(" WITH ")
		sb.WriteString(c.WithOption)
	}
	return sb.String()
}

// SQL returns the full SQL string for this CREATE MATERIALIZED VIEW statement.
func (c *CreateMaterializedViewStatement) SQL() string {