Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    9

    Cool Unanswered: A Matter of Style

    When creating SQL scripts, what methods do you use when working with them?

    More specifically:
    How do you split the SQL across files? For example, do you put things relating to each table into separate files (table creation, indexes for the table, etc.), or do you group similar things into the same file (all indexes in one file, all table creation in another file, etc.)? Maybe you just have ONE BIG file that contains all the code?

    Thanks for your input!

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97
    We have all SQL statements related to the same table
    grouped into one file:
    create table
    create index
    grants

    This is good for us, since we have many developers
    who often ask for changes in tables. If we wanted
    to have an easy way of re-installing the app in another
    machine, we'd probably have chosen to create few
    files containing absolutely everything.

    We also add comments about when and who requested
    a change.

    Regards,
    Mariano Corral

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •