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 happens in bind step in a db2 program?

What do you need to do before you do EXPLAIN?

How to fetch the last row from the table in SQL (db2)?

why we create view.

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

What is cursor stability?

The only place of VSAM KSDS in DB2 is?

What are the contents of dclgen?

What is the syntax for seeing the columns and data types of a table in the db2 database?

What is a DB2 plan?

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

For more DB2 Interview Questions Click Here