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 發表在 痞客邦 PIXNET 留言(0) 人氣()