Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newbie3
Starting Member
1 Post |
 Posted - 2010-09-29 : 09:07:28
|
| Hello Guys,I am working on a new project in OBIEE. I am asked to do the data modeling in the database using oracle sql developer. I have to create the joins based on the reporting requirements. I have the tables created already. But the primary keys for few tables are not defined PK-FK joins are also not done properly. My questions are(1) If I have to define the primary key for the existing tables can I do that using the alter table command or should I create the table all over again and then define it?(2) If I have to make the changes in the existing PK-FK joins how do i go about doing that?Please let me know guys. Thank You. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-09-29 : 10:35:45
|
| If you are working with an Oracle database, you should ask your question on a forum for Oracle questions. This site if for questions about Microsoft SQL Server.You might try here:http://www.dbforums.com/oracle/CODO ERGO SUM |
 |
|
|
|
|
|
PK-FK joins