What kind of problems may I see if a process drop and re-create a set of tables every night?
foreign key constraint.
you won't be able to support replication at least without dropping it also
database fragmentation
|||It depends on your schema and database. You can have foreign keys, indexed views, schema bound objects referencing tables and there are also the soft dependencies (code that accesses the table). It would help if you explain what you are doing or trying to do? Why do you have to drop and recreate set of tables every day? Are they staging tables?
No comments:
Post a Comment