Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

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

Please provide your feedback in the comments section above. Please don't forget to follow.