I am trying to execute the following Create Table Statement for creating a Queue Table in Teradata and i am getting a syntax error. But as per the syntax diagram and the examples in the documentation, the syntax is correct. Can any one help me out in rectifying this?
create table quetable1, queue (create_timestamp timestamp(6) not null default current_timestamp(6), a int, b int);
The error i am getting is Code = 3706. 3706: Syntax error: Expected a CHECKSUM keyword.
I am using Teradata SQL Assistance for executing the script.