Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when making change to table
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00718501
Message ID:
00718531
Views:
22
Hi Allan,
I never encountered that, but it sounds like the table is corrupted. Try to generate script for this table and see if it's okey. If it's, drop the table and recreate it from the script.

>Hi Sergey,
>
>I didn't specify a default value. When I try to set the default value to 0, I get the following error message:
>
>
>'InvoiceHeader' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Type ??meric is not a defined system type.
>
>
>
>
>>Hi Allan
>>
>>You cannot add field with NO NULLS attribute w/o default value. What's default value for that column?
>>
< snip >
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform