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: Monday, November 17, 2014 2:13 AM
Points: 276, Visits: 241
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: Today @ 3:08 PM
Points: 13,206, Visits: 12,687
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