Editing table design

Is there anyway possible to edit table design with data already entered in the table.
If not, is there anyway I can cut and paste the info back in.
Ive tried importing to access and then back to SQL, however,
when i tried to view my table design in ASP.NET webmatrix, it gave me an error.Try the link below for ALTER Table in SQL Server. Run a search for same in SQL Server BOL(books online) to do the same in Enterprise Manager. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp