Don't you just hate it when you've created a Document Type in Kentico that is full of data and for some reason you need to rename it. I know I do.
Even though Kentico does give you the ability to rename your Document Types via its interface, the old table name still exists within the SQL database. This may not bother some developers but this makes me feel damn right dirty.
I came across an SQL script Matt Lee wrote in his blog, that takes the hassle of renaming the tables manually within a Kentico database.
Definitely check it out. It has saved me a lot of time.
Source: SQL Script To Rename A Document Type Table