Using Foreign Keys to Determine Table Insertion Order in TSQL, Sql Server

Language: Layout:

WITH
      ctefk (pktable, fktable) AS (
                  SELECT
                        s1.name + '.' + o1.name AS pktable
                      , ISNULL(s2.name + '.' + o2.name, '') as fktable
                  FROM sys.objects o1
                  LEFT OUTER JOIN sys.sysforeignkeys fk ON o1.object_id = fk.fkeyid
                  LEFT OUTER JOIN sys.objects o2 ON o2.object_id = fk.rkeyid
                  LEFT OUTER JOIN sys.schemas s1 ON o1.schema_id = s1.schema_id
                  LEFT OUTER JOIN sys.schemas s2 ON o2.schema_id = s2.schema_id
                  WHERE o1.type_desc = 'user_table'
                  AND o1.name NOT IN ('dtproperties', 'sysdiagrams')
                  GROUP BY
                        s1.name + '.' + o1.name
                      , ISNULL(s2.name + '.' + o2.name, '')
            ),
      cterec (tablename, fkcount) AS (
                  SELECT
                        tablename = pktable
                      , fkcount =   0
                  FROM ctefk

UNION ALL

SELECT
                        tablename = pktable
                      , fkcount =   1
                  FROM ctefk
                  CROSS APPLY cteRec
                  WHERE ctefk.fktable = cteRec.tablename
                  AND ctefk.pktable <> cteRec.tablename
            )
SELECT
      TableName
    , insertorder = DENSE_RANK() OVER (ORDER BY MAX(fkcount) ASC)
FROM (
      SELECT
            tablename = fktable
          , fkcount =   0
      FROM ctefk
      GROUP BY
            fktable

UNION ALL

SELECT
            tablename = tablename
          , fkcount =   SUM(ISNULL(fkcount, 0))
      FROM cterec
      GROUP BY
            tablename
) x
WHERE x.tablename <> ''
GROUP BY
      tablename
ORDER BY
      insertorder ASC
    , TableName ASC
;

View schema
Execution time: 0,14 sec, rows selected: 4, rows affected: 0, absolute service time: 0,3 sec