Tuesday, 4 November 2014

Truncate in Teradata

In teradata, we do not have Truncate command as such but below is the command which work similar to the Truncate command:-

DELETE FROM DATABASE_NAME.TABLE_NAME ALL;

If you have HR database and Employee table then:-

DELETE FROM HR.EMPLOYEE ALL;




No comments:

Post a Comment