Method parseShowStmt

parser/parser_table.go:1516–1641

(pos Pos)

}

func (p *Parser) parseShowStmt(pos Pos) (*ShowStmt, error) {
	if err := p.expectKeyword(KeywordShow); err != nil {
		return nil, err
	}

	var showType string
	var target *TableIdentifier

	// Parse the type of SHOW statement
	switch {
	case p.matchKeyword(KeywordCreate):
		// SHOW CREATE TABLE table_name
		showType = "CREATE"
		_ = p.lexer.consumeToken()

		if err := p.expectKeyword(KeywordTable); err != nil {
			return nil, err
		}
		showType += " TABLE"

		tableIdent, err := p.parseTableIdentifier(p.Pos())
		if err != nil {
			return nil, err
		}
		target = tableIdent

	case p.matchKeyword(KeywordDatabases):
		// SHOW DATABASES [optional clauses]
		showType = "DATABASES"
		_ = p.lexer.consumeToken()

	case p.matchKeyword(KeywordTables):
		// SHOW TABLES
		showType = "TABLES"
		_ = p.lexer.consumeToken()

	default:
		return nil, fmt.Errorf("expected CREATE, DATABASES, or TABLES after SHOW, got %q", p.last().String)
	}

	stmt := &ShowStmt{
		ShowPos:  pos,
		ShowType: showType,
		Target:   target,
	}

	// Parse optional clauses for SHOW DATABASES
	if showType == "DATABASES" {
		// Parse [[NOT] LIKE | ILIKE '<pattern>']
		if p.matchKeyword(KeywordNot) {
			stmt.NotLike = true
			_ = p.lexer.consumeToken()
		}

		if p.matchKeyword(KeywordLike) || p.matchKeyword(KeywordIlike) {
			if p.matchKeyword(KeywordLike) {
				stmt.LikeType = "LIKE"
			} else {