ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

How can i change the column name.

Question Posted / sanjay

Answer Posted / sanjay

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1052

Explain the difference between function and stored procedure?

993

Explain what are sparse columns?

1062

What is cached report?

150

How to get the definition of a user defined function back?

1084

What does the on update no action do?

1073

What does the on delete cascade option do?

1060

Where are sql server usernames and passwords stored in the sql server?

1167

What the different types of Replication and why are they used?

1127

What are the grouping functions?

971

How can i Relate Tables in SSIS

1134

What is sql sandbox in sql server?

1290

Explain about temporary stored procedure?

1088

What is the difference between DATETIME2 and DATETIME?

1124

Explain what are the basic functions for master, msdb, model, tempdb databases?

1022