By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

how can a change a column named 'population * 1.1' with oher name?

P: 1
i cannot change column name "population * 1.1" with another name...
i try with alter modify, alter change.. nothing
i try puting the expression column in quotes..nothing..
i try all things..
Feb 4 '12 #1
Share this Question
Share on Google+
1 Reply


P: 2
ok bro you want to change the column name with help of query so your solution is
here
first you create the one table
like
create table thug
(
name varchar(10),
address varchar(20),
)
now i want to change the column name like address from the table thug
please see this query
sp_rename 'thug.address',sammy
'thug.address' in this first is [table name.column name(where you want to change)]
sammy is new column name
Feb 17 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.