How to delete a table from SQL Server "memory"

Asked

Viewed 242 times

0

I had a table called tb_state in an SQL Server database and deletes it, when trying to create a table with the same name the system returns error stating that it already exists, how do I delete the table from the database memory ?

sql-server

  • You deleted by interface or by code ? Strange because I’ve never seen it happen

  • Via interface, the same error occurs with stored procedures.

  • guy already tried by code? drop table name_table

  • I tried yes, it informs that deleted, but when trying to save returns error.

  • So, to work I had to close and open sql server. Every time I delete an object from the database I need to open and close the application.

  • See if it helps : http://stackoverflow.com/questions/9792379/drop-table-in-sql-server-by-sql-server-management-studio

Show 1 more comment

1 answer

0


Always start your queries with: USE [Nomedobanco] If you are using Management Studio, check the "Avoid Saving Changes..." field in Tool/Options/Design is unchecked.

Ferramentas'/Opções

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.