In article <04c301c4aa45$45485490$c802a8c0@martijnlaptop>,
"Martijn Tonies" <m.tonies@stripped> writes:
> This is plain rubbish. See my other example with a more complicated
> view source. When adjusting the view, or extracting a script - the
> view source becomes complete gibberish.
> MS SQL, or Firebird, for example, store the view-source as defined -
> this includes comments, spacing etc etc... In short: it becomes usuable.
> MySQL should do this too. From reading these lists, I think MySQL
> only stores the resulting structure - or something similar - and
> (currently) not the view source. To make views useful, better change
> it... :-)
Nope. A standards-compliant database is _required_ to store the
structure of its objects in its internal information_schema, not some
SQL string. Of course MySQL isn't standards-compliant at all, but we
should not make it worse by imitating the quirks of other DBMSs.