Geek Answers Handbook

__RefactorLog table in SQL Server - is it safe to delete it?

SSDT (I suspect) creates a table called __RefactorLog in any database that you point to.

If I hit the release, is there any harm in deleting this table, since I see no benefit from including it in the schema creation script during deployment?

I do not see this as a flaw, but I would like to ask a question to knowledgeable people here to see if there is something that I am missing ...

+4
source share
1 answer

It is created by SSDT when you use refactoring in SSDT (e.g. Refactor -> Rename), if you do the deployment, and just clear the table that it will repeat to do any old refactoring that could just fail or cause a catastrophe!

If you clear the table, make sure that you also delete entries from the refactorlog.xml file in your project - the file is pretty obvious.

Make sure you are not trying to deploy the old dacpac (I think this is unlikely anyway)

Ed

+6
source

More articles:


All Articles