> I suppose these are the ways with Databases. They don't work the way
> we like them to.
> So please adjust with it. For this matter I think, any RDBMS will be
> doing their or paddings to the scripts when they are loading it in
> just the same way for oracle(where i have some (in)experience). so,
> "don;'t worry, be happy".
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
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL