What is a LIKE table and how is it created?

Question Posted / guest

2 Answers
5596 Views
I also Faced
E-Mail Answers

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 multi row fetch in db2?

0 Answers

What is coalesce in db2?

0 Answers

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers IBM,

What is a dbrm in db2?

0 Answers

How can you count the number of rows from a table tab?

0 Answers

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers

Explain the use of the WHERE clause.

2 Answers IBM,

What does CURRENTDATA option in bind indicate

1 Answers IBM,

What is the difference between plan and package in db2?

0 Answers

What is reorg?

0 Answers

How is the SUBSTR keyword used in sql?

1 Answers

When would you prefer to use VARCHAR?

3 Answers

For more DB2 Interview Questions Click Here