ALTER table _tablename_ ADD _columnname_ datatype To add "middlename" (varchar, 30 char max) to the "users" table: ex: ALTER table USERS ADD MIDDLENAME varchar(30)
-----Original Message----- From: imogenkhan imogenkhan [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:52 PM 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
