A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
Question
Book Icon
Chapter 3, Problem 4RQ
Program Plan Intro

Common data type used to define columns:

The data type is used to store the type of data which should be specified for the column in a table.

Some of the commonly used data types are:

  • CHAR(n)
  • VARCHAR(n)
  • DATE
  • DECIMAL(p,q)
  • INT
  • SMALLINT

Program Plan Intro

Common data type used to define columns:

The data type is used to store the type of data which should be specified for the column in a table.

Some of the commonly used data types are:

  • CHAR(n)
  • VARCHAR(n)
  • DATE
  • DECIMAL(p,q)
  • INT
  • SMALLINT

Program Plan Intro

Common data type used to define columns:

The data type is used to store the type of data which should be specified for the column in a table.

Some of the commonly used data types are:

  • CHAR(n)
  • VARCHAR(n)
  • DATE
  • DECIMAL(p,q)
  • INT
  • SMALLINT

Program Plan Intro

Common data type used to define columns:

The data type is used to store the type of data which should be specified for the column in a table.

Some of the commonly used data types are:

  • CHAR(n)
  • VARCHAR(n)
  • DATE
  • DECIMAL(p,q)
  • INT
  • SMALLINT

Blurred answer
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning