• i am vipul and i use this method to truncate all table from database. but constraint was not enabling by

    Exec sp_MSforeachtable 'alter table ? check constraint all'

    print 'all constraint enable'

    MESSAGE WILL APPEAR THAT- 'all constraint enable'

    BUT WHEN I CHECK THE DATABASE ALL CONSTRAINT DISABLE

    SO WHAT I SHOULD DO ENABLE AGAIN ALL THE CONSTRAINT

    VIPUL SACHAN