Loading

Table Structure copy

Sai Reddy

8y801

Question 1) If i take table structure through script to create new table with the same structure, will i get indexes also which were created on columns?

Question 2) If i took full back today and deferential back up tommarow, while restoring which one i need to restore first full or deferential?

Question 3) table 1 had 3 rows and table 2 had 3 rows.

then select * from table1,table2 why 9 rows will come, why not 6?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gagan Sharma8y ago
Accepted answer
Answer 1: NO
Answer 2: full
Answer 3: It work as cross join as you did not mentioned table Joining condition.