SQL Object - SQL Prompt Standard

  1. SQL Prompt finds invalid objects

    Release Notes: Updates in V5.0 Find Invalid Objects SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want ... to know if objects are referencing other objects that no longer exist in the database. Script Object as ALTER from a query window If you are navigating a query that contains a reference to an object, SQL ... Prompt 5 enables you to script out that object directly from the query window by pressing F12. View column dependencies SQL Prompt 5 enables you to view a list of objects that reference a column. SQL ...

  2. About SQL Prompt Standard

    Description: Intelligent code completion and layout for MS SQL Server. SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code ... ON syntax completion Expand wildcard to column names list Object creation-SQL viewing pane Mouse-over tool tips that give object definitions including a useful summary Parameter hinting for user-defined ... functions Cross-database queries Distributed queries with linked SQL Server instances Scripted objects included in candidate list Cursors, cursor variables, and related statements Auto-uppercasing of keywords ...

  3. Features of SQL Prompt Standard

    Features: Feature Standard Pro Supported for Visual Studio Code completion • • • Instant access to schema information • • • SQL snippets • • • Statement expansion • • • Find invalid objects • •   Search • •   ... Column dependencies • • • Auto-generation of aliases • • • Script as ALTER from query window • •   Wildcard expansion- single instance • • • Wildcard expansion- entire script   • • Format SQL   •   Decrypt ... encrypted objects   •   Summarize scripts   •   Find unused variables and parameters   •   Qualify object names   •   Smart rename   •   Split table   •   Encapsulate as stored procedure   •   Uppercase ...

  4. SQL Prompt Standard Compatibility

    Compatibility: Operating System for Deployment Windows Vista Windows XP Windows Server 2003 Windows 2000 Architecture of Product 32Bit Product Type Application Compatible Containers Microsoft SQL Server 2008 ... Microsoft SQL Server 2005 Microsoft SQL Server 2000 Disk Space Required: 200MB Memory Required: 256MB minimum, 500MB recommended Software Required: One or more of the following editors: SQL Server Management ... Studio 2005, SQL Server Management Studio 2008, SQL Server Management Studio Express 2005, Visual Studio 2005, Visual Studio 2008 or Query Analyzer Other Special Requirements: MDAC 2.8,.NET Framework 2.0 ...

  5. SQL Prompt Standard Prices

    Pricing: ...

  6. SQL Prompt Standard Licensing

    Licensing: ...