All,
For example :
I want to add 2 audit fields on all 300 tables of my data model.
CreateOn DATETIME NOT NULL,
CreateBy CHAR ( 7 ) NOT NULL,
Can I write a script to do it ?
Thanks for helping.
Rgds.
John Lam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DISCLAIMER NOTE
==========================
This e-mail and any files transmitted with it is AIT-confidential
and intended solely for the use of the individual or entity to
whom it is addressed.
If you are not the intended recipient, or the person responsible
for delivering the e-mail, be advised that you have received this
e-mail and any files transmitted with it in error and that any
use, dissemination, forwarding, printing, or copying of this
e-mail and any files transmitted with it is strictly prohibited.
If you have received this e-mail and any files transmitted with
it in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you very much for your co-operation.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************