Post reply

model database

  • May 13, 2008 at 12:56 pm

    #154347

    hi,

    I just a doubt regarding the model database.

    It is said that in model database we can store templates of tables which we can use for further use in other databases .So can anyone help me out and tell me how can we use those template tables in other databases.Please give me the procedure for that.Thank u all in advance

  • May 13, 2008 at 1:08 pm

    #814748

    The model database is "copied" when you create a new database. So if you create a table in it, such as a tally or numbers table. Then all subsequent databases that you create on that instance will have that table in them. This also applies to views, procedures and functions....

    I would warn you though, be very selective on what you place here as it will go in ALL newly created databases.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

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

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