Start Insufficient base table information for updating or refreshing

Insufficient base table information for updating or refreshing

(In this model, the Table Dependency class is acting as an intersection table for implementing a many-to-many relationship between suppliers and consumers).

However, storing both the expanded form and the original view definition text as well can also be useful for both DESCRIBE readability as well as functionality (see later section on ALTER VIEW v RECOMPILE).

Update 7-Jan-2010: Rather than adding full-blown unparse support to the AST model, I'm taking a parser-dependent shortcut.

ANTLR's Token Rewrite Stream provides a way to substitute text for token subsequences from the original token stream and then regenerate a transformed version of the parsed text.

A typical use case might be to create an interface layer with a consistent entity/attribute naming scheme on top of an existing set of inconsistently named tables, without having to cause disruption due to direct modification of the tables.