|
Noel4001
Starting Member
USA
1 Posts |
 Posted - 08/14/2007 : 09:02:54
|
I am new to SQL 2000 and was wondering if it is possible to drop a table and keep the trigger?
We are recreating the table shortly after it is dropped but want to keep the triggers to attach to the newly created table. We are moving data from database to another database. There is a third party app that is why we recreate the table. The third party app that assigns the trigger to the table when it is origianlly created using its interface, but not when we move data via the SQL engine. |
|
Drop Table Keep Trigger
