Loading

Database changes table stored procedure etc?

Database changes table stored procedure etc?

Tahir Ansari

Tahir Ansari

Hi all,

we have large database and we need to change all tables name,stored procedures name,sql server agents etc...

any idea how to do that fast and any impact when we do this..

any suggestions

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke3y ago
Accepted answer
First, it would be nice to know what is the purpose of such an activity. Meaning, standardization, consistency, etc.

Second, can you please give us an example existing name and proposed name.

It is simple as well as complex at the same time.

It is the dependent objects which can be difficult to manage.

Otherwise, you can use metadata to generate object renaming script.

Hope it hleps!
+3
Rajesh Gami3y ago
If you want to identify all stored procedures referring to a particular table then use the below query
```
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'
```
+4
Tahir Ansari3y ago
fore.g table name is tbl_employee so we need to changes tbl_employees or tbl_emp1 etc

stored procedures name is proc_getemp then change to proc_empget, empget, etc.

how to find how many tables are connected to stored procedures
+1