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

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

what is identity columns in TD?

Question Posted / sunil

Answers were Sorted based on User's Feedback



what is identity columns in TD?..

Answer / tdguy

Identity Columns are system generated numbers for every row
as it is inserted in the table.These columns ensure row
uniqueness in a table.
create table emp
(empno integer
generated always as identity
max value 1000
)
primary index(empno);

Is This Answer Correct ?    3 Yes 0 No

what is identity columns in TD?..

Answer / yuvaevergreen

Identity column is a system generated value. Used for row
uniqueness. If rows need to be unique, then ALWAYS option
should be used with NO CYCLE option. Separate DBC table
takes care of identity columns DBC.idcol.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Teradata Interview Questions

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  

Explain BYNET.

0 Answers  

How many types of index are present in teradata?

1 Answers  

Explain the term 'columns' related to relational database management system?

0 Answers  

What is meant by Teradata Gateway?

0 Answers  

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

Can we collect statistics on multiple columns?

0 Answers  

What are types of partition primary index (ppi) in teradata?

0 Answers  

What interface is used to connect to windows based applications?

0 Answers  

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  

Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

For more Teradata Interview Questions Click Here
Categories