ALTER TABLE tablename ADD columnname datatype etc. You should see if you can get a copy of the SQL "Books Online" (MS SQL documentation). It can be a little difficult to understand at first, but it has all of this syntax info. I've found it invaluable for SQL Server development.
-----Original Message----- From: imogenkhan imogenkhan [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 10:52 AM To: SQL Subject: Adding a column How do you add a column to an existing table for MS SQL server? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
