***********************
Your mail has been scanned by InterScan.
***********-***********


Hello,



Can I know the syntax to create a table with 'LIKE' keyword
so as to copy the structure of existing table?



Also, I would like to whether the aforementioned syntax
would also copy constraints and indexes?



Thanks and regards

Dharmesh B






***********************************************************************************
This message is for the named addressees' use only. It may contain NSDL

confidential, proprietary or legally privileged information. If you receive

this message in error, please immediately delete it. You must not, directly

or indirectly, use, disclose, distribute, print, or copy any part of this message

if you are not the intended recipient.Unless otherwise stated, any commercial

information given in this message does not constitute an offer to deal on

any terms quoted. Any reference to the terms of executed transactions

should be treated as preliminary only and subject to our formal written

confirmation.
***********************************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page