Method SQL

pkg/sql/ast/sql.go:826–867

SQL returns the full SQL string for this CREATE INDEX statement including the UNIQUE modifier, IF NOT EXISTS, USING method, column list, and WHERE predicate.

()

// SQL returns the full SQL string for this CREATE INDEX statement including
// the UNIQUE modifier, IF NOT EXISTS, USING method, column list, and WHERE predicate.
func (c *CreateIndexStatement) SQL() string {
	if c == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("CREATE ")
	if c.Unique {
		sb.WriteString("UNIQUE ")
	}
	sb.WriteString("INDEX ")
	if c.IfNotExists {
		sb.WriteString("IF NOT EXISTS ")
	}
	sb.WriteString(c.Name)
	sb.WriteString(" ON ")
	sb.WriteString(c.Table)

	if c.Using != "" {
		sb.WriteString(" USING ")
		sb.WriteString(c.Using)
	}

	sb.WriteString(" (")
	cols := make([]string, len(c.Columns))
	for i, col := range c.Columns {
		s := col.Column
		if col.Direction != "" {
			s += " " + col.Direction
		}
		cols[i] = s
	}
	sb.WriteString(strings.Join(cols, ", "))
	sb.WriteString(")")

	if c.Where != nil {
		sb.WriteString(" WHERE ")
		sb.WriteString(exprSQL(c.Where))
	}

	return sb.String()
}

// SQL returns the SQL representation of this ALTER TABLE statement.
// Note: the parser returns AlterStatement (in alter.go); this method