CREATE TABLE AAA LIKE TABLE BBB;

What is a LIKE table and how is it created?

Question Posted / s

Answer Posted / s

CREATE TABLE AAA
LIKE TABLE BBB;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain about rct in db2?

1109

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is consistency token in db2?

1143

What do you mean by between and in? Is between inclusive of specified range values?

1092

What is page size in db2?

975

What is the use of runstats in db2?

1110

What is database alias db2?

1127

What are the various isolation levels possible?

1122

How do you pull up a query which was previously saved in qmf?

1151

what is the responsibility of the construction superintendent

2147

Highlight all the advantages that are attached to a package.

1119

What is access path in db2?

986

Give the name of some fields form sqlca.

1079

What is nvl in db2?

1093

If I have a view which is a join of two or more tables, can this view be updateable?

1139