Re: Create a table only if the table doesn't exists

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:dafq92tac12l3vhip5amcsn5qu8is60pac_at_4ax.com...
: On Sat, 24 Jun 2006 14:54:03 +0200, "Joseph Balsamo" <r5tr_at_free.fr>
: wrote:
:
: >> Better but still a very bad idea. What is the business case for
: >> implementing a known bad practice of creating tables with procedural
: >> code?
: >
: >Just for my information, may I ask why it is a bad practice ?
: >
:
: Databases happen to be designed. Adding tables on the fly is not a
: proper design procedure.
: You create your tables in a relational database management system.
: How can any DBA guarantee consistency, when your program is treating
: the database as a replacement for flat files, or as a replacement for
: a garbage bin?
:
: --
: Sybrand Bakker, Senior Oracle DBA

Sybrand, have you guys every heard of installation scripts?

++ mcs Received on Sat Jun 24 2006 - 15:05:39 CDT