Breaking News: Grepper is joining You.com. Read the official announcement!

create table sql

Add Answer

Matteoweb answered on July 14, 2020 Popularity 10/10 Helpfulness 6/10

answer create table sql

related how to create table in sql

related create table sql

related sql create table

related create table in sql

related creating a table in sql

related create table sql

related SQL CREATE TABLE Statement

related creating table in sql

related sql create table

create table sql

Comment

CREATE TABLE table_name(
  	id INT AUTO_INCREMENT PRIMARY KEY,  
  	name VARCHAR(255), # String 255 chars max
  	date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  	longtext BLOB
);

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: create-table sql

Link to this answer
Share Copy Link

Contributed on Jul 14 2020

Matteoweb

0 Answers Avg Quality 2/10

Closely Related Answers

how to create table in sql

Comment

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Jan 28 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

create table sql

Comment

CREATE TABLE Persons (
    PersonID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    LastName VARCHAR(255),
    FirstName VARCHAR(255),
    Address VARCHAR(255),
    Number INT NOT NULL
);

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Sep 08 2022

Ill Iguana

0 Answers Avg Quality 2/10

sql create table

Comment

CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Feb 12 2021

Blue Badger

0 Answers Avg Quality 2/10

create table in sql

Comment

--Syntax for MySQL

CREATE TABLE Persons (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (Personid)
);

-- Syntax for SQL Server
CREATE TABLE Persons (
    Personid int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Jun 14 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

creating a table in sql

Comment

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 28 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

create table sql

Comment

# During table creation
# MySQL and SQL Server
CREATE TABLE table_name (
  id INT PRIMARY KEY NOT NULL [AUTO_INCREMENT],
  col2 VARCHAR(50),
  col3 DECIMAL(6,2) CHECK(col3>0),
  FOREIGN KEY (other_id) REFERENCES Other_Table(id) [ON DELETE CASCADE]
);

# PostgreSQL
CREATE TABLE table_name (
  id SERIAL PRIMARY KEY,
  col2 VARCHAR(50),
  col3 DECIMAL(6,2) CHECK(col3>0),
  FOREIGN KEY (other_id) REFERENCES Other_Table(id) [ON UPDATE NO ACTION]
);


# If table already exists
# Adding primary key in MySQL, PostgreSQL and SQL Server 
ALTER TABLE table_name
ADD CONSTRAINT table_pkey 
PRIMARY KEY (col1,col2);

# Adding foreign key in MySQL, PostgreSQL and SQL Server 
ALTER TABLE table_name
ADD CONSTRAINT table_fkey
FOREIGN KEY (col1) REFERENCES Other_Table(id);

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Feb 19 2023

Innocent Iguana

0 Answers Avg Quality 2/10

SQL CREATE TABLE Statement

Comment

CREATE TABLE Companies (
  id int,
  name varchar(50),
  address text,
  email varchar(50),
  phone varchar(10)
);

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on May 22 2022

SAMER SAEID

0 Answers Avg Quality 2/10

creating table in sql

Comment

CREATE TABLE courses(
    course_id INT NOT NULL AUTO_INCREMENT,
    course_name VARCHAR(50) NOT NULL,
    PRIMARY KEY (course_id)
);

INSERT INTO courses(course_name)
VALUES('Btech'),
('BCA'),
('MBA');

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.yahoobaba.net

Tags: sql

Link to this answer
Share Copy Link

Contributed on Aug 31 2022

Poised Pigeon

0 Answers Avg Quality 2/10

sql create table

Comment

Creates a new table .
Example: Creates a new table called ‘users’ in the ‘websitesetup’ database.
CREATE TABLE users (
id int,
first_name varchar(255),
surname varchar(255),
address varchar(255),
contact_number int
);

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Lorenzo Satta Chiris

0 Answers Avg Quality 2/10

create table sql

Contents

More Related Answers

create table sql

Closely Related Answers

how to create table in sql

create table sql

sql create table

create table in sql

creating a table in sql

create table sql

SQL CREATE TABLE Statement

creating table in sql

sql create table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.