create table oracle
CREATE TABLE ot.persons( person_id NUMBER GENERATED BY DEFAULT AS IDENTITY, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL, PRIMARY KEY(person_id) );
create table oracle
CREATE TABLE ot.persons( person_id NUMBER GENERATED BY DEFAULT AS IDENTITY, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL, PRIMARY KEY(person_id) );
create table sql
# Simple table describing a vehicle CREATE TABLE vehicle( # vehicleId: Unique ID for Primary Key. # This is how we will reference a record vehicleId INT NOT NULL, make VARCHAR(64), # String 64 chars max model VARCHAR(128), derivative VARCHAR(255), PRIMARY KEY(vehicleId) ); # Add a record INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
Create Table
CREATE TABLE users ( id SERIAL PRIMARY KEY, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, created TIMESTAMP, modified TIMESTAMP ); CREATE TABLE articles ( id SERIAL PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE, created TIMESTAMP, modified TIMESTAMP, UNIQUE (slug), FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE tags ( id SERIAL PRIMARY KEY, title VARCHAR(191), created TIMESTAMP, modified TIMESTAMP, UNIQUE (title) ); CREATE TABLE articles_tags ( article_id INT NOT NULL, tag_id INT NOT NULL, PRIMARY KEY (article_id, tag_id), FOREIGN KEY (tag_id) REFERENCES tags(id), FOREIGN KEY (article_id) REFERENCES articles(id) ); INSERT INTO users (email, password, created, modified) VALUES ('cakephp@example.com', 'secret', NOW(), NOW()); INSERT INTO articles (user_id, title, slug, body, published, created, modified) VALUES (1, 'First Post', 'first-post', 'This is the first post.', TRUE, NOW(), NOW());
sql create table
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 );
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us