In article <[EMAIL PROTECTED]>, "Martijn Tonies" <[EMAIL PROTECTED]> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]