How do you Generate Sequence in Teradata?

Answer Posted / sridhar

using identity we can generate sequence
syntax:

generated always/by default as identity (start with <value> increment by <value> min<value> max<value> no cycle)..

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the five phases that come under MultiLoad Utility.

586


What is multi insert?

628


How do you do backup and recovery in teradata?

551


What is the purpose of indexes?

591


What are some commonly used bteq scripts?

566






Difference between stored procedure and macro?

689


What are the different functions included in the server software?

603


What is a three-tier data warehouse?

633


How to load specific no.of records using bteq, or fastload,or multiload

1317


Why do you get spool space errors? How do trouble-shoot them?

593


What are the different functions performed in development phase?

572


What is collect statistics?

589


Define views in teradata with general syntax.

574


What are the joins in teradata and how many types of joins are there in teradata?

569


any one answer me how they can analyzing the project using data ware housing?

2026