-
Changing a column name (MS SQL 2000)
How can you change a Column name for MS SQL 2000 ?
something like :
ALTER TABLE [dbo].[MyTable]
OldName RENAME NewName
GO
thank you
-
Renaming a coloumn in SQL2K
EXEC sp_rename 'Tablename.[oldColumn]','NewColumn','COLUMN'
Thanks
R.A.F
-
with ' ?
'COLUMN' looks strange but I try
thank you
-
That's the syntax, tells sql you want to rename column. You can use it to rename other kinds of object as well.
-
I keep it somewhere thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|