Method parseCreateStatement

pkg/sql/parser/ddl.go:41–153

parseCreateStatement parses CREATE statements (TABLE, VIEW, MATERIALIZED VIEW, INDEX)

()

// parseCreateStatement parses CREATE statements (TABLE, VIEW, MATERIALIZED VIEW, INDEX)
func (p *Parser) parseCreateStatement() (ast.Statement, error) {
	// Check for modifiers: OR REPLACE, TEMPORARY, TEMP
	orReplace := false
	temporary := false

	for {
		if p.isType(models.TokenTypeOr) {
			p.advance() // Consume OR
			if !p.isType(models.TokenTypeReplace) {
				return nil, p.expectedError("REPLACE after OR")
			}
			p.advance() // Consume REPLACE
			orReplace = true
		} else if p.isTokenMatch("TEMPORARY") || p.isTokenMatch("TEMP") {
			p.advance() // Consume TEMPORARY/TEMP
			temporary = true
		} else {
			break
		}
	}

	// Determine object type
	if p.isType(models.TokenTypeMaterialized) {
		p.advance() // Consume MATERIALIZED
		if !p.isType(models.TokenTypeView) {
			return nil, p.expectedError("VIEW after MATERIALIZED")
		}
		p.advance() // Consume VIEW
		return p.parseCreateMaterializedView()
	} else if p.isType(models.TokenTypeView) {
		p.advance() // Consume VIEW
		return p.parseCreateView(orReplace, temporary)
	} else if p.isType(models.TokenTypeTable) {
		p.advance() // Consume TABLE
		return p.parseCreateTable(temporary)
	} else if p.isType(models.TokenTypeIndex) {
		p.advance()                      // Consume INDEX
		return p.parseCreateIndex(false) // Not unique
	} else if p.isType(models.TokenTypeUnique) {
		p.advance() // Consume UNIQUE
		if !p.isType(models.TokenTypeIndex) {
			return nil, p.expectedError("INDEX after UNIQUE")
		}
		p.advance()                     // Consume INDEX
		return p.parseCreateIndex(true) // Unique
	} else if p.isMariaDB() && p.isTokenMatch("SEQUENCE") {
		seqPos := p.currentLocation() // position of SEQUENCE token
		p.advance()                   // Consume SEQUENCE
		stmt, err := p.parseCreateSequenceStatement(orReplace)
		if err != nil {
			return nil, err
		}
		if stmt.Pos.IsZero() {
			stmt.Pos = seqPos
		}
		return stmt, nil
	}