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

How many codd's rules are satisfied by teradata database?

1055


What is real time and near real time data warehousing?

1073


Explain the term 'primary key' related to relational database management system?

995


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1735


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1176


What is a three-tier data warehouse?

1064


What does sleep function does in fast load?

1073


Explain the new features of teradata?

998


What is teradata? Also, list out some of the primary characteristics of teradata.

995


How to run a query in teradata?

1016


What is TPD?

1318


Explain teradata architecture?

1037


How to identify ppi columns?

1118


What is the use of virtual processor connectivity in teradata?

954


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

1067