T-SQL script for delete all rows from MDS entity

truncate table stg.[TableName_Leaf]

insert into stg.[TableName_Leaf]
(
ImportType
,ImportStatus_ID
,BatchTag
,Code
)
select
4 as ImportType
,0 as ImportStatus_ID
,'DeleteALL' as BatchTag
,Code
from
mdm.TableName -- Integration Management View

exec stg.[udp_TableName_Leaf] @VersionName = 'VERSION_1', @LogFlag = 0, @BatchTag = 'DeleteALL'