To determine table used in stored procedure or table reference
We need to run following command
Go
SELECT object_Name(Id)as objectName,text FROM syscomments WHERE text like '%tblUser%'
Go
We can use following command as well
Go
SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION like '%tblUser%'
GO
In the above queries we have used tblUser as table name we can replace it and add any other table name which we want to find.
Enjoy!!!
We need to run following command
Go
SELECT object_Name(Id)as objectName,text FROM syscomments WHERE text like '%tblUser%'
Go
We can use following command as well
Go
SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION like '%tblUser%'
GO
In the above queries we have used tblUser as table name we can replace it and add any other table name which we want to find.
Enjoy!!!
No comments:
Post a Comment