What is a LIKE table and how is it created?

Question Posted / guest

Answers were Sorted based on User's Feedback

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

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

More DB2 Interview Questions

What is the syntax required for the creation of a cursor?

What are the advantages of using a PACKAGE?

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

What is a lock?

What is cobol db2?

What is meant by isolation level?

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

how to fetch first 100 rows in db2

What is bind and rebind in db2?

max number of columns in a db2 table?

How do you concatenate the firstname and lastname from emp table to give a complete name?

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

For more DB2 Interview Questions Click Here