What is a LIKE table and how is it created?

Answers were Sorted based on User's Feedback



What is a LIKE table and how is it created?..

Answer / s

CREATE TABLE AAA
LIKE TABLE BBB;

Is This Answer Correct ?    2 Yes 0 No

What is a LIKE table and how is it created?..

Answer / nag(igate)

the like will create the same table structure and it will
not copy data from existing table.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is meant by dclgen?

0 Answers  


What are the various isolation levels possible?

0 Answers  


what is difference between Plan and Package

1 Answers   Syntel,


How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  






What is meant by concurrency?

1 Answers  


What do you mean by NOT NULL? When will you use it?

3 Answers  


Why do we use cursor?

0 Answers  


What are catalog tables in db2?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


What is a synonym ?

2 Answers  


Categories