if you rename any of Kentico's own tables you probably get errors for sure! Is there a good reason you want to rename table names? Is this a one time thing?
Since you seem to change the tables directly in SQL, Kentico's staging module wouldn't even know you've changed something.
Also it might be possible the table names are used in other (custom) queries or code...
So I'd be very careful updating tables names.