{{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.
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...