USE [colombo]
GO
-- create table Items
CREATE TABLE [dbo].[Items]
(
[ItemCode] [nvarchar](25) NULL,
[ItemName] [nvarchar](100) NULL,
[Price] [float] NULL
) ON [PRIMARY]
GO
/*
-- Alter Column name syntax
sp_rename @objname = {'TableName.ColumnName'},
@newname = {'New-ColumnName'}, @objtype = {'COLUMN'}
*/
-- Alter Column name
EXEC sp_rename
@objname='Items.ItemName',
@newname='Item_Name',
@objtype='COLUMN'
GO
-- ALTER TABLE NAME
EXEC sp_rename
'Items', 'Items_New'
GO
|