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