Error message

  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 687 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 690 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 691 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 692 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 695 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in drupal_environment_initialize() (line 697 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).
  • Warning: ini_set() has been disabled for security reasons in include_once() (line 267 of /home/sqlxdeta/public_html/web/sites/default/settings.php).
  • Warning: ini_set() has been disabled for security reasons in include_once() (line 268 of /home/sqlxdeta/public_html/web/sites/default/settings.php).
  • Warning: ini_set() has been disabled for security reasons in include_once() (line 276 of /home/sqlxdeta/public_html/web/sites/default/settings.php).
  • Warning: ini_set() has been disabled for security reasons in include_once() (line 283 of /home/sqlxdeta/public_html/web/sites/default/settings.php).
  • Warning: ini_set() has been disabled for security reasons in drupal_settings_initialize() (line 791 of /home/sqlxdeta/public_html/web/includes/bootstrap.inc).

Screenshots

Usage

Picture


With text cursor at your table, procedure or any other object name, press SQL XDetails hotkey and voilà !


Source code of procedures, view, triggers...

Picture


One-click transfer of source code to sql editor. Supports procedures, functions, views, triggers - any code in database.

This example examines sys.objects view with SQL XDetails.



Foreign keys

Picture

 

Columns of multicolumn foreign key are in-line of a foreign key, comma separated.


Primary key

Picture


Supports multicolumn primary keys


Table columns

Picture
Foreign key columns display referenced (parent) table and column.
Works also with multicolumn foreign keys.


Space used by each index

Picture
You can see total amount of space used by table together with indexes, just like sp_spaceused. But here you also see that space broken down to each index. Clustered index contains table data in leaf nodes.


Index INCLUDED columns

Picture


In addition to index key columns, SQL 2005 and on also supports index included columns. They are placed just in leaf nodes of index, as a clustered indexes with subset of columns. Use it to overcome 16-columns limit of indexes or to place varchar(max) and other types not allowed in key columns.


Indexes on Table-valued functions

Picture


Table-valued functions can also have multiple indexes and constraints defined on returning table. SQL Details gives you insight to them.

And many more features and otherwise hidden information about your database.

Download and investigate for yourself!