how I can Drop a Column or modify the lenght of this column?

[FluFFy05]

Is because i have a field <br>&quot;Quantity integer 8&quot; <br>and i what to change for<br>&quot;Quantity integer 15&quot; <br>And i don't know do that ??<br>Thanks Fluffy

 

[foxdev]

There are two issues here, Fluffy:&nbsp;&nbsp;the one you asked, and the one you didn't.<br><br>The one you asked:&nbsp;&nbsp;you can right-click on the table and choose Design Table in the Enterprise Manager, and change a column's properties there.&nbsp;&nbsp;You can also use the ALTER TABLE command.<br><br>The one you didn't ask:&nbsp;&nbsp;integers are <b>always</b> 4 bytes in storage space, and can stoare a value as high as 2,147,483,647. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[vkamath]

Are you talking about right-clicking on the table? I cant find the &quot;Design Table&quot; option at all in SQL Server Enterprise Manager. Please help. My reqmnt. is the same as Fluffy's.

 

[RickCole]

In SQL Server 7.0 upwards the right click design option on a table is available. If you 6.5 or before you will have to do this via an SQL script.

Rick.