By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
USE master;
Changed database context to 'master'.
SELECT t.Name,
t.object_id,
t.type_desc,
t.create_date,
ISNULL((SELECT i.name,
i.type_desc,
i.is_unique,
i.is_primary_key
FROM sys.indexes i
WHERE i.object_id = t.object_id
AND type <> 0
FOR JSON PATH, INCLUDE_NULL_VALUES),JSON_ARRAY()) indexes
FROM sys.tables t
FOR JSON PATH, INCLUDE_NULL_VALUES;
| JSON_F52E2B61-18A1-11d1-B105-00805F49916B |
|---|
| [{"Name":"spt_fallback_db","object_id":117575457,"type_desc":"USER_TABLE","create_date":"2003-04-08T09:18:01.557","indexes":[]},{"Name":"spt_fallback_dev","object_id":133575514,"type_desc":"USER_TABLE","create_date":"2003-04-08T09:18:02.870","indexes":[]},{"Name":"spt_fallback_usg","object_id":149575571,"type_desc":"USER_TABLE","create_date":"2003-04-08T09:18:04.180","indexes":[]},{"Name":"spt_monitor","object_id":1803153469,"type_desc":"USER_TABLE","create_date":"2022-10-08T06:31:55.523","indexes":[]}] |