Transcription of Structured Query Language
{{id}} {{{paragraph}}}
Available Online: Structured Query Language Hans-Petter Halvorsen Structured Query Language Hans-Petter Halvorsen Copyright 2017 3 Table of Contents 1 Introduction to SQL .. 6 Data Definition Language (DDL) .. 8 Data Manipulation Language (DML) .. 8 2 Introduction to SQL Server .. 9 SQL Server Management Studio .. 10 Create a new Database .. 11 Queries .. 12 3 CREATE TABLE .. 13 Database Modelling .. 15 Create Tables using the Designer Tools .. 17 SQL Constraints .. 17 PRIMARY KEY .. 18 FOREIGN KEY .. 19 NOT NULL / Required Columns .. 22 UNIQUE .. 23 CHECK .. 25 DEFAULT .. 27 AUTO INCREMENT or IDENTITY.
• Oracle • MySQL (Oracle ... , Toad Data Modeler, PowerDesigner, Visio, etc. This is called Database Modeling. The CREATE TABLE statement is used to create a table in a database. Syntax: CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type,
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}