|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 26th, 2004, 03:12 PM
|
|||
|
|||
Change Tables Field Size ie. varchar(50) to varchar(100) - SQL Server 2000
I'm pretty deep into a web application I'm building for my current employer. It's about 90% done, 3 weeks of work. Because of this I do not want to change the setup of the project.
I would ideally like to be able to change the size of fields in a table. Such as, varchar(50) to varchar(100). I'm just wondering if the resizing is possible. Another problem I am having is renaming a table. I've seen the syntax for it but everytime I try it doesn't work. My code: if not form_in_new_name = "" then sSQL = "RENAME " & form_in_name & "_table TO " & form_in_new_name & "_table ;" Set rs2 = cn.Execute(sSQL) Set rs2 = Nothing Thanks for the help in advance!
|
|
#2
February 26th, 2004, 03:22 PM
|
||||
|
||||
|
1) Can't you just change the size in Enterprise Manager?
2) You need to use the alter table command, like this Code:
If(Len(form_in_new_name) <> 0) then sSQL = "ALTER TABLE '" & form_in_name & "'_table RENAME TO '" & form_in_new_name & "'_table" Set rs2 = cn.Execute(sSQL) Set rs2 = Nothing End If BTW, In the future please post you questions in the proper forum. The Code Bank is for sample code only, not for questions. Last edited by Memnoch : February 26th, 2004 at 03:25 PM.
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Change Tables Field Size ie. varchar(50) to varchar(100) - SQL Server 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
