Hi.
I want a way by which i can change field name for each table in my access/sql server 2005 database.
Means for each table containing "desc" field name as to change with "desc1"
How to do it with coding or with some specific command ?
:o
Printable View
Hi.
I want a way by which i can change field name for each table in my access/sql server 2005 database.
Means for each table containing "desc" field name as to change with "desc1"
How to do it with coding or with some specific command ?
:o
You use the alter table command.
alter table tblname
rename column oldcolname to newcolumnname
but this gives me error as "synatax error "
For SQL Server use sp_Rename stored proc.
a quick google search
http://www.google.com/search?hl=en&r...Server&spell=1
did you even try and look this up?