Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rename a culomn

Status
Not open for further replies.
jass1220

jass1220

Programmer
Joined
May 20, 2003
Messages
88
Location
AE
how i can rename a culomn in sql ..i want to give the field different name ..?
 
Sort by date Sort by votes
There is no such function in ANSI SQL.

It is supported by some DBMS so you are better of posting this in a forum dedicated to the DBMS that you are using.
 
Upvote 0 Downvote
While you can't rename the column in the database, you can rename the field in the report or a new file by using a SELECT field1 AS newfieldname.

VTJ
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
windows command in a sql script
Replies
1
Views
606
carp
carp
BobThornton
  • Locked
  • Question Question
Count records until a record value changes
Replies
2
Views
821
carp
carp
BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
586
carp
carp
ahadali79
  • Locked
  • Question Question
Getting a part of string
Replies
2
Views
487
johnherman
johnherman
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
440
harfri
harfri

Part and Inventory Search

Sponsor

Back
Top