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

Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?

Answer Posted / bhanu prasad

We can find the information of all the indexes in the
system table "dbc.indices"

Is This Answer Correct ?    19 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1248


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1159


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

2487


Give a justifiable reason why Multi-load supports NUSI instead of USI.

1159


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2125


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1047


What is upsert statement in teradata?

1143


Explain parsing engine in teradata?

1098


During the Display time, how is the sequence generated by Teradata?

1067


What is spool space?

1163


What do you mean by teradata intellicloud?

1042


What is a three-tier data warehouse?

1122


How can you track login parameters of users in teradata?

1198


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

1752


Mention a few of the ETL tools that come under Teradata.

1081