Msg 2715 Level 16 - Cannot find data type NUMBER

Transact sql error message Msg 2715 Level 16 - Column, parameter, or variable #1: Cannot find data type NUMBER.

Msg 2715 Level 16 Example:


GO
CREATE TABLE products(
product_id NUMBER NOT NULL,
name VARCHAR(250) NOT NULL,
description VARCHAR(4000),
avaible VARCHAR(3),
price NUMBER );
GO

Message
Msg 2715, Level 16, State 6, Line 1
Column, parameter, or variable #1: Cannot find data type NUMBER.

Modify number with numeric


GO
CREATE TABLE products(
product_id NUMERIC NOT NULL,
name VARCHAR(250) NOT NULL,
description VARCHAR(4000),
avaible VARCHAR(3),
price NUMERIC );
GO

Message
Command(s) completed successfully.

Other error messages: