Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Error Messages (Msg 173): The definition of column <Column Name> must include a data type. 

Pooja Goel  |   Dec 15, 2019  |  Views: 241


Lets suppose You are executing the given query in SQL Server.


(ID  Primary Key,
Gender NOT NULL,
ContactNo NOT NULL,
Status )


Error Message :

But getting the below errors. 

Msg 173, Level 15, State 1, Line 3
The definition for column 'ID' must include a data type.



Causes :

In above SQL statement, Data types are not assigned to columns so above error message is occurred.


Solution of the Error :

Assign the data type to all columns when you are creating table in SQL Server. You can follow the listed data types for columns as per requirement.


  • Exact numeric (bigint, bit, decimal, int, money, numeric, smallint, smallmoney, tinyint)
  • Approximate numeric (float, real)
  • Date and time (date, datetime2, datetime, datetimeoffset, smalldatetime, time)
  • Character strings (char, varchar, text)
  • Unicode character strings (nchar, nvarchar, ntext)
  • Binary strings (binary, varbinary, image)
  • Other data types (cursor, hierarchyid, sql_variant, table, timestamp, uniqueidentifier, xml)

Here is the correct way to create table statement.


(ID  int Primary Key,
Name  Varchar(50) NOT NULL,
Gender  Char(1) NOT NULL,
ContactNo Numeric(18,0) NOT NULL,
Status Char(1))




Output :

ID NAME Gender ContactNo Status

Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.

Read related articles

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+