Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Renameing a column in all tables in a sql 2008 database Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 8:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 4:31 AM
Points: 278, Visits: 242
kk thanks for your reply.... but i try to ask how to drop that column.... i cannot drop that column.... nice article very useful to me.......

Manik
You cannot get to the top by sitting on your bottom.
Post #1403639
Posted Monday, January 7, 2013 8:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:05 PM
Points: 13,327, Visits: 12,820
manik123 (1/7/2013)
kk thanks for your reply.... but i try to ask how to drop that column.... i cannot drop that column.... nice article very useful to me.......


I don't understand. You don't have to drop the column, you just have to refer to it correctly. Perhaps if you posted the ddl of the existing table and the t-sql you are trying to run it would help.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1403659
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse