SQLTeam.com | Weblogs | Forums

SQL recreate my drooped tables :(


#1

Hi all

i had setup an program to do something "i forget this program"
this program create some of tables in my database

SQL_AUDIT_TYPE0
SQL_AUDIT_TYPE0_ALERTS
SQL_AUDIT_TYPE0_DASHBOARD
SQL_AUDIT_TYPE0_THA
SQL_HM_TYPE0
SQL_HM_TYPE0_ALERTS
SQL_HM_TYPE1
SQL_HM_TYPE1_ALERTS
SQL_HM_TYPE2
SQL_HM_TYPE2_ALERTS
SQL_HM_TYPE3
SQL_HM_TYPE3_ALERTS
SQL_HM_TYPE4
SQL_HM_TYPE4_ALERTS

when i try to drop it the command is successful but SQL recreate it again :frowning:

the program is fully uninstalled now and this database on our server not in local machine


#2

I read the post a few times but still can't see what your problem or question is.


#3

Scroll up one level in the object browser,right-click and select Refresh. Then check to see if the dropped table is still listed.


#4

those tables created by an program i was installed it in my computer.
i was uninstalled this program and those tables still on my database.
i want to drop this tables so i use drop table command, the command executed successfully but when i refresh tables i found it again...


#5

this is after refresh ... see my other reply


#6

Either:

  1. you didn't refresh the tables view after the drop
  2. you're looking in a different database

After the DROP command, try this:

use <name of database>
GO

select * from sys.tables
where name = 'SQL_AUDIT_TYPE0_DASHBOARD'

If the DROP succeeds, this query should return no results


#7

the drop executed successfully..
the problem was in installed an program that created some files on my local machine,These files are responsible for creating tables.
so i was delete these files and drooped tables from my database and no longer exist.
thanks all


#8

there is probably a DDL trigger.

check in

select    *
from    sys.triggers