Whats wrong with this query?

[astrait]

trying to create a table using a query, and I'm not sure whats wrong with this query:

CREATE TABLE FYIAdmin
(
 FYI_ID COUNTER CONSTRAINT PRIMARY KEY,
 FYI_Title varchar(100),
 FYI_Text memo,
 FYI_Date date
)

Sorry it its noobish

 

[RV]

Not sure which environment you're using (Access or SQL Server or whatever).
Anyway, you're using non-existing data types.
For instance, Access doesn't have a varchar datatype.
SWL Server doesn't have a datatype memo.

Rv