SQL statement Modify table field name/modify fields length/Add Field/delete field

Modify field names
Exec sp_rename ' zxchem_suggest.end_date ', ' yj_finish_date ', ' Column '

Modify field length
Alter Table Zxchem_suggest ALTER Column yj_finish_date Varchar (Ten) not Null

Add Field
ALTER TABLE DOCDSP add Dspcode char (200)

Delete a field
ALTER TABLE table_name DROP COLUMN column_name

modifying field types
ALTER TABLE table_name ALTER COLUMN COLUMN_NAME NEW_DATA_TYPE

http://www.samool.com/archives/41369/

SQL statement Modify table field name/modify fields length/Add Field/delete field