Sai Reddy

Sai Reddy

  • 1.8k
  • 212
  • 16.1k

Table Structure copy

Dec 14 2017 11:29 PM
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?

Answers (1)