Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change SQL column from numeric(3,0) to numeric(6,0)
Message
From
20/12/2022 00:58:45
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01685524
Message ID:
01685528
Views:
39
>>>Hi,
>>>
>>>I am trying to write a code (in a .prg) that would change a SQL Server column size from numeric(3,0) to numeric(6,0). But I can't.
>>>Anyone can suggest a code to make such a column size change?
>>
>>ALTER TABLE (?)
>>https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql
>
>Thank you. I will need to, first, create a t-sql command that will be used to check if the column is numeric(3,0) or (6,0). Then to ALTER the table.

No need to write much code. https://www.vfphelp.com/vfp9/_5wn12psb4.htm

In your case I don't recommend numeric(6,0), use Integer in stead.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform