The basic SQL statement to create a table in a database is CREATE TABLE. What additional information is required in the statement besides CREATE TABLE?

What will be an ideal response?


One of the pieces of information that is required when creating a table is the name of the table. The table
name is supplied after the words CREATE TABLE. Following the table name is a parenthesized, comma-separated list of fields
/ columns for the table, along with their datatype and other characteristics such as being a PRIMARY KEY field.

Computer Science & Information Technology

You might also like to view...

Give an example of a protocol mechanism that hides an error.

What will be an ideal response?

Computer Science & Information Technology

The Chart ________ walks you through creating a chart

A) Creation tool B) Developer C) Wizard D) Formatting tool

Computer Science & Information Technology

Information in an Access report is often easier to read and comprehend when it is separated into ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

In information security, a specification of a model to be followed during the design, selection, and initial and ongoing implementation of all subsequent security controls is known as a __________.

A. framework B. security plan C. security standard D. blueprint

Computer Science & Information Technology