What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-02 00:27:01
check index sql server
create procedure _ListIndexes(@tableName nvarchar(200)) as begin /* exec _ListIndexes '<YOUR TABLE NAME>' */ SELECT DB_NAME(DB_ID()) as DBName,SCH.name + '.' + TBL.name AS TableName,IDX.name as IndexName, IDX.type_desc AS IndexType,COL.Name as Colum... Add solution