This is a view in the mssqlsystemresource database. Returns a row for each SQLOS threads running under the SQL Server process.
CREATE VIEW sys.dm_os_threads AS SELECT * FROM OpenRowSet(TABLE SYSTHREADS)