By 25/02/2016 2 Comments

What Is CREATE TABLE Statement In SQL?

  • SQL CREATE TABLE statement creates a new table in a database.
  • Tables are collections of rows and columns.
  • In SQL, table columns are called attributes and rows are called records.
  • Each table has a name.
  • SQL CREATE TABLE statement creates a table, set its name, column names, data types and columnĀ length.

Syntax:

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size)
);

Example: MySQL

CREATE TABLE country
(
country_id BIGINT(11),
country_name VARCHAR(200),
country_location VARCHAR(200),
country_zipcode INT(60)
);

Note:







Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .