This might need to be 3 individual requests but I will chance my luck that it is just one....

I have a table A which has constraints, triggers and indexes that need to be moved to table B

What's the syntax for identifying what these are and / or for moving these ?

Thanks
--
Brett Exton



________________________________
Please do not print this email unless absolutely necessary.
Peidiwch ag argraffu'r neges e-bost hon oni bai fod hynny'n gwbl angenrheidiol.

________________________________________________________________________
This e-mail and any attachments transmitted with it represents the
views of the individual(s) who sent them and should not be regarded
as the official view of Bridgend County Borough Council. The contents
are confidential and intended solely for the use of the addressee. If
you have received it in error, please inform the system administrator
on (+44) 01656 642111.

This e-mail and any attachments have been scanned with 'MessageLabs SkyScan' - http://www.messagelabs.com/

________________________________________________________________________
Mae'r e-bost hwn ac unrhyw atodiadau a drosglwyddir gydag ef yn cynrychioli safbwyntiau'r unigolyn a'i anfonodd (unigolion a'u hanfonodd) ac ni ddylid eu hystyried fel safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwys yn gyfrinachol ac wedi'i fwriadu ar gyfer y sawl y'i cyfeiriwyd ato yn unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwr y system ar (+44) 01656 642111.

Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs SkyScan' - http://www.messagelabs.com/
________________________________________________________________________

Oracle LazyDBA home page