drop and re-create table

What kind of problems may I see if a process drop and re-create a set of
tables every night?A Biggy: You will lose all access permissions that have been set for the
tables -unless you add steps to recreate the permissions on the tables.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:801C90E1-5D1B-4171-8B49-CCAFF38563FC@.microsoft.com...
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>|||JIM.H. wrote:
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>
Why not just TRUNCATE them?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

drop and re-create table

What kind of problems may I see if a process drop and re-create a set of
tables every night?A Biggy: You will lose all access permissions that have been set for the
tables -unless you add steps to recreate the permissions on the tables.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:801C90E1-5D1B-4171-8B49-CCAFF38563FC@.microsoft.com...
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>|||JIM.H. wrote:
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>
Why not just TRUNCATE them?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

drop and re-create table

What kind of problems may I see if a process drop and re-create a set of tables every night?

It will be helpful to explain why you need to drop tables on a daily basis.

drop and re-cerate table

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?