Tcode to see the sql join

[Former Member]

What is the tcode to see how the tables are related in sql.

[daixiong_jiang3]

an alternative tool can help you.please refer to transaction SQVI. type a quickview name and then click the CREATE button.

in the next screen, give a description in the TITLE, choose the datasource as Table join,then enter.

in the third screen,click the second button named Insert table or just shiftf1, you can insert the first table(you need to type the table name),then shiftf1 again, you can add another table.then you can see the link between the two tables.

if you want to add many tables,just do shift+f1 again and again

[Former Member]

Hi,

go to SQ02, there give the sample infoset name then press 'Create' button, fill the 'name' and select the radio button 'Table join by basis table' enter the table name against to that radiobutton field, press enter, then you can get the table given along with some pushbutton in application tool bar there select the "insert table" button , A popup will ask you for the another table name, enter the table name and press enter, which will display the related fields in those 2 tables, like wise you can give another table also, if you don't want the other table you can have the 'delete' button by choosing that table.

Reward if useful.

Thanks,

Sreeram.

[Former Member]

Hi i hv d list of TCodes,if u hv gv me ur mailid.i wl forward.