Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain the meaning of Amp?

1052


How is MLOAD Client System restarted after execution?

1070


In general, how do you optimze any sql in teradata?

984


What happens in a conflict? How do you handle that?

998


What is the purpose of joins in teradata and what are the available join types?

1014


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3550


Highlight the advantages of PPI(Partition Primary Index).

1017


What is spool space?

1086


What is the maximum number of dml can be coded in a multiload script?

1064


What are the steps to create a data model?

991


While creating table my dba has fallback or no fallback in his ddl. What is that?

1121


What do you mean by caching in teradata?

1000


How many tables can you join in v2r5?

1009


Name the five phases that come under MultiLoad Utility.

939


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

971