By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab(id INT PRIMARY KEY, i INT);
CREATE INDEX MyHypIndex ON tab(i) WITH STATISTICS_ONLY = 0;
SELECT name, is_hypothetical
FROM sys.indexes
WHERE object_id = OBJECT_ID('tab')
| name | is_hypothetical |
|---|---|
| PK__tab__3213E83F990A036A | False |
| MyHypIndex | True |