• BOL - Restrictions

    You cannot use TRUNCATE TABLE on tables that:

    •Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.)

    Do we have any chance to use a table that has a foreign key that references itself?

    --------------------------------------
    ;-)“Everything has beauty, but not everyone sees it.” ― Confucius