Collections:
sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using sys.indexes in SQL Server?
✍: FYIcenter.com
Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links":
USE FyiCenterData; GO SELECT * FROM sys.indexes WHERE object_id = ( SELECT object_id FROM sys.tables WHERE name = 'fyi_links' ); GO object_id name index_id type_desc is_unique --------- ------------- -------- ---------- --------- 421576540 NULL 0 HEAP 0 421576540 fyi_links_id 2 NONCLUSTERED 0 421576540 fyi_links_url 3 NONCLUSTERED 0
The extra line in the query result is not a real index at this moment. It will be explained in another tutorial.
⇒ DROP INDEX - Removing Existing Indexes in SQL Server
⇐ SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
2016-11-15, 1925🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...