{{theTime}}

Search This Blog

Total Pageviews

SQL Server: How to list all the indexes for a table

Use the in-build stored procedure 'sp_helpindex' to list all the indexes on a table.
Syntax: 'EXEC sp_helpindex 'table_name' on any sql editor.

No comments:

Windows 8.3 file naming setting is disabled for the product

To enable Windows 8.3 file naming setting use fsutil command Example:  c:\> fsutil 8dot3name set C: 0