Very Computer

by **David M. Gonde** » Fri, 16 Apr 1999 04:00:00

I set a record size to 100 characters in a SQL 6.5 table. I now need to
increase the size. What is the best/easiest way to accomplish this.

Thank you in advance.

David M. Gondek

by **John Woel** » Fri, 16 Apr 1999 04:00:00

I assume you really me a "field" size to 100. The easiest way to accomplish
this is to upgrade to SQL 7.0!!! I you stay with 6.5 you will have to
create a temporary table with you current data in it, the drop your current
table (Yikes!) and recreate it with the expanded size!!!

>I set a record size to 100 characters in a SQL 6.5 table. I now need to
>increase the size. What is the best/easiest way to accomplish this.

>Thank you in advance.

>David M. Gondek

by **Mikael Wedha** » Fri, 16 Apr 1999 04:00:00

Visual database tools will do that for you. (Comes with VB 5 Enterprise, for
one)

--
Mikael Wedham, Sweden
Please! No mail unless I ask for it.

>I assume you really me a "field" size to 100. The easiest way to
accomplish
>this is to upgrade to SQL 7.0!!! I you stay with 6.5 you will have to
>create a temporary table with you current data in it, the drop your current
>table (Yikes!) and recreate it with the expanded size!!!

>>I set a record size to 100 characters in a SQL 6.5 table. I now need to
>>increase the size. What is the best/easiest way to accomplish this.

>>Thank you in advance.

>>David M. Gondek

by **Wayne Snyde** » Fri, 16 Apr 1999 04:00:00

In sql 6.5

you will have to rename the table...

create a new table (with the old name) changing the column that you want..

insert into newtable select * from oldtable...

you will also have to
1. recreate the indexes, views, etc.
2. drop and recreate all of the sp's, and triggers.
3. be sure to re-apply all permissions...

It is kind of a pain in sql 6.5, but you can do it... Third pary tools (like
Embarcadero's DBArtisan) also make this quite easy.... Sql 7.0 also offers
better support for this kind of thing.

--
Wayne Snyder MCSE, MCT, SQL Server MVP
IKON Technology Services, C*te, NC Education
(Please respond to the newsgroup.)

Very Computer

Simple Question...hopefully simple answer

Simple Question...hopefully simple answer

Simple Question...hopefully simple answer

Simple Question...hopefully simple answer

Simple Question...hopefully simple answer