SQLServer:如何对按外键依赖关系排序的表名进行排序

WITH RECURSIVE FK_Sort AS (
    SELECT
        TC.TABLE_NAME,
        TC.CONSTRAINT_NAME,
        RCON.UNIQUE_CONSTRAINT_NAME,
        RCON.UNIQUE_CONSTRAINT_CATALOG,
        RCON.UNIQUE_CONSTRAINT_SCHEMA,
        RCON.UNIQUE_CONSTRAINT_TABLE_NAME,
        1 AS LEVEL
    FROM
        INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
        INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RCON ON TC.CONSTRAINT_NAME = RCON.CONSTRAINT_NAME
    WHERE
        TC.CONSTRAINT_TYPE = 'FOREIGN KEY'
        AND TC.TABLE_CATALOG = 'YourDatabase'
        AND NOT EXISTS (
            SELECT
                *
            FROM
                INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC2
                INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RCON2 ON TC2.CONSTRAINT_NAME = RCON2.CONSTRAINT_NAME
            WHERE
                TC2.CONSTRAINT_TYPE = 'FOREIGN KEY'
                AND TC2.TABLE_CATALOG = 'YourDatabase'
                AND RCON2.UNIQUE_CONSTRAINT_CATALOG = TC.TABLE_CATALOG
                AND RCON2.UNIQUE_CONSTRAINT_SCHEMA = TC.TABLE_SCHEMA
                AND RCON2.UNIQUE_CONSTRAINT_TABLE_NAME = TC.TABLE_NAME
        )

    UNION ALL

    SELECT
        TC.TABLE_NAME,
        TC.CONSTRAINT_NAME,
        RCON.UNIQUE_CONSTRAINT_NAME,
        RCON.UNIQUE_CONSTRAINT_CATALOG,
        RCON.UNIQUE_CONSTRAINT_SCHEMA,
        RCON.UNIQUE_CONSTRAINT_TABLE_NAME,
        FKS.LEVEL + 1 AS LEVEL
    FROM
        INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
        INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RCON ON TC.CONSTRAINT_NAME = RCON.CONSTRAINT_NAME
        INNER JOIN FK_Sort AS FKS ON FKS.TABLE_NAME = RCON.UNIQUE_CONSTRAINT_TABLE_NAME
    WHERE
        TC.CONSTRAINT_TYPE = 'FOREIGN KEY'
        AND TC.TABLE_CATALOG = 'YourDatabase'
)
SELECT
    TABLE_NAME,
    LEVEL
FROM
    FK_Sort
ORDER BY
    LEVEL ASC;