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

Source code of procedures, view, triggers…

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

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

Primary key

Supports multicolumn primary keys

Table columns

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

Space used by each index

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

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

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!

Comments are closed.