top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Can we use volatile tables in tera data?

+4 votes
376 views
Can we use volatile tables in tera data?
posted Dec 11, 2013 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You are working in a Teradata database application. You have to CREATE a table and insert some records for performance analysis. You have to DROP the table once you have done with your job. If this is the case, will you think a smart way for this?

Yeah. Teradata gives VOLATILE option with CREATE TABLE syntax.

CREATE VOLATILE TABLE TABLE_NAME
(
COLUMN_1 DATATYPE,
COLUMN_2 DATATYPE
) PRIMARY INDEX (COLUMN_1)
ON COMMIT [PRESERVE/DELETE] ROWS;

More about VOLATILE:

  1. You can have 1000 volatile tables in an active session.
  2. CHECK and REFERENTIAL constraints are not allowed.
  3. DEFAULT clause not allowed.

Here VOLATILE says, DO and GO.. i will take care...

answer Feb 1, 2014 by Amit Kumar Pandey
...