廣告贊助

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);

創作者介紹
創作者 dreamtails 的頭像
dreamtails

回憶......!

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