If you need to change the name of a SQL table but have references to the name in VB, VC++, etc., go ahead and change it in SQL then open your Application’s code. Use the ‘Edit | Replace . . .’ (Ctrl + H for you keyboard buffs) function to find the instances where you’ve used the table name and replace them with the new table name.
Happy Programming!