Change naming conventions in SQL Server In SQL Server 2014 we need to change naming convention for indexes and  keys. The old naming convention is not following any standards. My questions are: 


How can we change the naming convention for 200 tables in a production server?
Can the naming be changed at once using some scripts, or do we have to change them one by one?


Edit:
Keys:
Primary or Foreign Key
You can use sp_rename to change the name of procedures, columns, tables, indexes, constraints. You'll have to do each object individually (although you can create a single script that renames the objects), and I would highly recommend running through a test environment first to ensure that you do not run into any problems.