Intoduction :-
Hii Friends...
This is an easy way to find tables, procedures, triggers which was made by you or your friends and you don't know the table or procedures name then you can simply fire below queries
with remember name like if your table name is tbl_Employee and procedure name is proc_ManageEmployee and trigger name is tgr_updateEmployee then you can fire query like below queries
1. for tables : select * from sys.tables where name like '%Employee%'
you will get tbl_Employee as result.
2. for procedures : select * from sys.procedures where name like '%Employee%'
you will get proc_ManageEmployee as result.
3. for triggers : select * from sys.triggers where name like '%Employee%'
you will get tgr_updateEmployee as result.
you can also put your own condition with these conditions like AND Id > 10 OR Mobile=123456789
Thank You !
Hii Friends...
This is an easy way to find tables, procedures, triggers which was made by you or your friends and you don't know the table or procedures name then you can simply fire below queries
with remember name like if your table name is tbl_Employee and procedure name is proc_ManageEmployee and trigger name is tgr_updateEmployee then you can fire query like below queries
1. for tables : select * from sys.tables where name like '%Employee%'
you will get tbl_Employee as result.
2. for procedures : select * from sys.procedures where name like '%Employee%'
you will get proc_ManageEmployee as result.
3. for triggers : select * from sys.triggers where name like '%Employee%'
you will get tgr_updateEmployee as result.
you can also put your own condition with these conditions like AND Id > 10 OR Mobile=123456789
Thank You !
0 comments:
Post a Comment