• Nice Question : )

    Yes we can not use truncate on a table which is referenced by a FOREIGN KEY constraint

    The below statement is true if it is not referenced with any FOREIGN KEY:

    If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used.