Post reply

Table Dependencies

  • January 26, 2004 at 1:43 pm

    #82145

    I recently started moving tables into file groups I've created.

    What I did was: create a file group and files for storage of the tables. I then created a temporary table to import my data from the old table to the temp table. I then renamed the current table and the primary key constraint with an 'old' extension. At this point, I received a warning about losing the dependencies on the table. I forged ahead anyway as this is how the developer wants the database setup. I then renamed the temp table to use the current table name and recreated all the indexes on the new table. (I did lose the dependencies for the stored procedures and views on the new table, but they still exist on the table renamed with the 'old' extension). Which will be deleted later after I verify everything works the way it should.

     

    Does anyone know of a sp that will recreate the dependencies on the new table or do I just need to drop and recreate the views and procedures?

     

    Thanks.

  • January 27, 2004 at 8:38 am

    #491767

    I don't know of an PS that will do what you want. You are probably going to have to do it manually.

    Something else you might consider though, is just moving the original tables over to the new file groups. You should be able to do this within Table Designer in EM. Look at the Properties in Table Designer and you will se a place to change it. Then your dependencies won't get broken.

    Chris

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

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