Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL65user
Starting Member
2 Posts |
 Posted - 2008-03-21 : 17:03:15
|
| Hi everyone,I have a question regarding SQL Server 6.5. I had a table that needed to have 2 columns made longer. From my research I discovered that you cannot simply change the length of these columns. Instead you need to create a new table, copy the data to that table, drop the original table and then rename the new table to the original table's name.I have done this, but the original table had some dependencies that are not being transferred over to the new table. Is there a way (preferably easy) to transfer these dependencies over to the new table?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:08:40
|
| Script them from original table then apply on new table. By the way, why can't modify column length? |
 |
|
|
SQL65user
Starting Member
2 Posts |
Posted - 2008-03-24 : 17:34:54
|
| Hi rmiao,Thanks for your response. From what I have read and have been told, you can not do this in SQL 6.5. If you know of a way that I can simply just change the column length, please let me know. That would be great and would save me a lot of headaches.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 21:36:35
|
| I have no sql6.5 to work with anymore, script should work. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 20:30:46
|
| You can't edit column.http://www.mssqlcity.com/FAQ/SQL65/EditCol.htm |
|
|
|
|
|
|
Table Dependencies - SQL 6.5