Re: Rename column
From: Luqman (pearlsoft_at_cyber.net.pk)
Date: 12/24/04
- Previous message: Luqman: "Cascade update in Oracle Constraint ?"
- In reply to: Daniel Crichton: "Re: Rename column"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Dec 2004 12:45:27 +0500
To rename a column in Sql Server, use sp_rename system procedure.
Rename a table
This example renames the customers table to custs.
EXEC sp_rename 'customers', 'custs'
B. Rename a column
This example renames the contact title column in the customers table to
title.
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
Best Regards,
Luqman
"Daniel Crichton" <msnews@worldofspack.co.uk> wrote in message
news:#r6Uz7Q6EHA.4008@TK2MSFTNGP15.phx.gbl...
> "SK" <SK@discussions.microsoft.com> wrote in message
> news:BCE6768A-C2A8-47F7-868A-D962C54CEA6F@microsoft.com...
> > that means SQL Server 7.0 is not SQL-92 compliant? I thought it claimed
to
> > be
> > SQL-92 compliant??
>
> Are you sure RENAME COLUMN is part of SQL-92? I can't see it in the SQL-92
> standard, and have found a few web sites which list it as an extension to
> SQL-92.
>
> Dan
>
>
- Previous message: Luqman: "Cascade update in Oracle Constraint ?"
- In reply to: Daniel Crichton: "Re: Rename column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
