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...

what is identity column in TD?

Answer Posted / yuvaevergreen

Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Comment whether bottleneck is an error or not.

1159


What is teradata?

1151


What is the purpose of upsert command?

1177


Highlight the advantages of PPI(Partition Primary Index).

1078


What are the things to be considered while creating secondary index?

1101


How to find duplicates in a table?

1218


What are the various etl tools in the market?

1073


What is real time and near real time data warehousing?

1118


What are teradata utilities?

1111


What is the opening step in basic teradata query script?

1038


Explain the types of join supports by teradata?

995


What is smp and mpp platforms?

972


Explain BYNET.

1005


What do you mean by parsing?

1113


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

2480