[thelist] SQL Server ALTER TABLE

[Les Lytollis]

Hi All,
 
I need to add a column to all tables (except system tables) in a SQL
Server DB. Is there a way to do:
 
<pseudocode>
ALTER TABLE * ADD [newcolumn] varchar (50)
WHERE [table] NOT [systemtable] 
</pseudocode>
 
TIA
Les Lytollis
Web Developer
 
 



********************Confidentiality Notice & Disclaimer ***********************
This message, together with any attachments, is for the confidential and exclusive use of the addressee(s).
If you receive it in error, please delete the message and its attachments from your system immediately and notify us by return e-mail.
Do not disclose, copy, circulate or use any information contained in this e-mail.

(1) Whilst we have taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses, we cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment.
(2) The sender shall remain solely accountable for any statements, representations or opinions that are clearly his or her own and not made in the course of employment.
***********************************************************************************