Database Object Finder
I have developed a tool which will search any database object in selected database. If you are not sure about the columns or triggers that in which table they below or you just remember few words of the object name and want to know about the object then this tool is suitable for you. No need to open sql server management studio, simple run this light weight tool and you will find what you will find what you want.
Lets go step by step to use this tool. Here is the first look of the tool when you run it.
Now enter your database server name and if it is using windows authentication then check the corresponding check box otherwise enter userid and password for connecting the database server. Here I am connecting server which is on my local and it is using windows authentication, so I will enter localhost in server address fields and will check windows authentication check box and will click on get database button to list all the available databases present on the server. Here is example screen print from my machine.
Here is one plus point of this tool, If you entered server detail one time then this tool will remember your entry and next time when you open this tool you have to simple select the server from the list as shown below
You have to simple select the database you want to search with in and everything will be filled up automatically. Database server details are stored in a file named as Credential.dk which is encrypted and you will not be able to modify it. This file is place under the same directory from where you are running this tool. See the below picture for the file.
And if you will delete this file then you will not be able to get your old records in the dropdown. You have to enter all details manually.
Lets proceed to next step. Select the database from the available options in the list box and if you remember the object name which starts with some character or end with some character or you simply know some character and dont know whether it is starting or ending character then select corresponding radio buttons and enter the text in the text box available. As you will type, search result will appear in the below grid. See below figure for more clarification.
In the above figure, all the objects whose name starts with sys or their definition starts with sys are listed in the grid. now if you want to get all the objects whose name or text ends with sys then simply select Ends with radio button and you dont have to type again. See the below figure :
So in this way you can search all the objects from your database. .Lets see the significance of the columns appeared in the search result.
1. Schema Name : Provides the schema name in which the current object belongs.
2. Object Name : is the name of the object being searched.
3. Type : Provides detail about the object like User Table, System Table, Procedure, Trigger, View etc. and if it is column then it provides column datatype with length and precision.
4. Match On : Provides details if the object found via its name or object definition contains the search text or any column which belong to table /view/procedure etc. definition.
5. Detail : This column is about the definition of the object like text of stored procedure/view/trigger etc. simply select the cell and press ctrl+c key to copy the definition.
6. Parent Object : It provides the detail about the parent object of the current object. Like table name of a column or table name of trigger, table name of keys etc.
If you want to search for some text across all the tables then don't forgot to download one of my tool SQL Table Data Search .
Download the tool from below installer link and provide your suggestions/feedback so that it can be improved more to solve your queries. I am going to combine my two tools(Database Object Finder and SQL Table Data Search) in a single tool and will publish it soon.
Lets proceed to next step. Select the database from the available options in the list box and if you remember the object name which starts with some character or end with some character or you simply know some character and dont know whether it is starting or ending character then select corresponding radio buttons and enter the text in the text box available. As you will type, search result will appear in the below grid. See below figure for more clarification.
In the above figure, all the objects whose name starts with sys or their definition starts with sys are listed in the grid. now if you want to get all the objects whose name or text ends with sys then simply select Ends with radio button and you dont have to type again. See the below figure :
So in this way you can search all the objects from your database. .Lets see the significance of the columns appeared in the search result.
1. Schema Name : Provides the schema name in which the current object belongs.
2. Object Name : is the name of the object being searched.
3. Type : Provides detail about the object like User Table, System Table, Procedure, Trigger, View etc. and if it is column then it provides column datatype with length and precision.
4. Match On : Provides details if the object found via its name or object definition contains the search text or any column which belong to table /view/procedure etc. definition.
5. Detail : This column is about the definition of the object like text of stored procedure/view/trigger etc. simply select the cell and press ctrl+c key to copy the definition.
6. Parent Object : It provides the detail about the parent object of the current object. Like table name of a column or table name of trigger, table name of keys etc.
If you want to search for some text across all the tables then don't forgot to download one of my tool SQL Table Data Search .
Download the tool from below installer link and provide your suggestions/feedback so that it can be improved more to solve your queries. I am going to combine my two tools(Database Object Finder and SQL Table Data Search) in a single tool and will publish it soon.
Nice blog, very helpful
ReplyDelete