1. The table doesn't have foreign key.

>> USE DatabaseName;

>> TRUNCATE TABLE TableName;

 

2. The table has foreign key.

>> USE DatabaseName;

>> DELETE [TableName];

>> DBCC CHECKIDENT('TableName', RESEED, 0);

arrow
arrow
    全站熱搜

    dreamtails 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄