c# - Changing column name in Visual Studio SQL feature -


i made mistake of labeling 2 columns , putting integers in titles , need change them because invalid. don't know in visual studio go change works across entire project. i've changed in design view of table still error

[sqlexception (0x80131904): invalid column name '13digiisbn'.

assuming using sql server.

try this:

exec dbo.sp_rename @objname = n'dbo.[yourtable].[13digiisbn]', @newname = n'newcolumnname' 

Comments