Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL "specified data type is not valid" error

Tags:

sql

Why does SQL server express 2008 give me this error?

CREATE TABLE model (
name varchar(3),
desc varchar(25)
)


0x80040E14, Minor Error 26302
> CREATE TABLE model (
name varchar(3),
desc varchar(25)
)
The specified data type is not valid. [ Data type (if known) = varchar ]

1 Answers

Because DESC is a SQL keyword. You can either use a different column name (say, description) or put brackets around desc:

[desc] VARCHAR(25)
like image 81
chaos Avatar answered Sep 03 '26 02:09

chaos



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!