xSQL Object Search SQL tool that locates database objects by checking their names and/or definition against a search criteria
Download

xSQL Object Search Ranking & Summary

xSQL Object Search Tags

search searcher sql system object SQL Searcher database search search definition Database Definition File Lock search criteria definition search definition database object finder jar file mobile play free mobile microsoft works free free cell phone simple floor plan l3d object object dog requirements definition tool

xSQL Object Search Description

xSQL Object Search is a simple tool that provides for locating database objects. You can search on one or multiple databases simultaneously, select from various search options, search for all or specific objects types, export the results to output files and more. With xSQL Object Search you will find the items you seek in no time. xSQL Object Search allows you to search SQL Server 2005 databases for objects that match a search pattern. The pattern you specify is matched against two properties of the database objects: name and definition. The name of an object is its identifier used when the object is created, it is the same name that appears in the Management Studio object tree. The definition, for the purpose of the search, is the T-SQL that defines the object. For a stored procedure, for example, the definition is the statement that was used to create the stored procedure. The definition of an object is not the same as the T-SQL script that can be used to re-create that object. A table, like all database objects, can be created via a T-SQL script, but has no definition in the database. The following are the database objects that have a definition: Views Stored Procedures (excluding CLR procedures, which have no definition in the database) User-Defined Functions (excluding CLR functions) Defaults (both constraints and stand-alone defaults) Rules DML Triggers (excluding CLR triggers) Database DDL Triggers Server DDL Triggers xSQL Object Search can search the names of the objects, their definitions (when the object has one) or both. The results of the search against each property are combined with AND or OR depending on the preferences to produce the final result set.Main features Search on one or all databases - choose to find the objects that meet the search criteria on one database or on all databases in the selected SQL Server. Support all types of database objects - from tables and views to CLR objects and Xml Schema Collections, you can search all database object types. Search the name or the definition - choose to search on the name of the objects, the T-SQL statement definition of the objects or on both. A range of search options: Exact: Searches for objects whose name or definition is exactly the same as the search text. Starts With: Locates objects whose name or definition starts with the specified search text. Ends With: Locates objects whose name or definition ends with the specified search text. Contains: Locates objects whose name or definition contains the specified search text. SQL Server Expression: Locates objects based a SQL Server expression. Any SQL Server functions and operators that can be used in the "where clause" of a query can participate in the SQL Server Expression criteria. Regular Expression: Locates objects whose name or definition meets a regular expression pattern. View object definition - view the T-SQL statement that defines the object with a click of a button. Export search results - easily export the result of the search to a comma-separated-value file. Simple and intuitive interface - a very simple interface allows you to finish your task with very few clicks. Asynchronous operations provides for a smooth search with status messages and counts.

xSQL Object Search Related Software