Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error when making change to table
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00718501
Message ID:
00718531
Vues:
23
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform