Post reply

creating database with out copying user defined objects in model

  • July 20, 2006 at 6:21 am

    #169016

    HI,

    Is there a way to create a new database with out copying all the user defined objects in the model database. I just need the system objects and from there I can create my own tables. Please let me know.

    Thanks,

    Sridhar.

  • July 20, 2006 at 8:21 am

    #650399

    If you don't want the user-defined objects to be in every database you create, you should remove them from the model database. Unless you do that, you will have to create the new DB then drop all the unwanted objects. Saving backups of empty databases is a useful way to keep 'templates' for databases. You can then restore the required backup to a new DB.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply