SQL recreate my drooped tables :(

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

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

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

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...

this is after refresh ... see my other reply

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

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

there is probably a DDL trigger.

check in

select    *
from    sys.triggers