SQL Set Operators Traditional Set Operators: Union Compatibility: Requirement for the traditional set operators. Strong requirement. - Same number of columns. - Each corresponding column is compatible. - Positional correspondence. Apply to similar tables by removing columns first. SQL UNION Example: Example 1: Retrieve basic data about all university people. SELECT FacNo AS PerNo, FacFirstName ...
CREATE TABLE Syntax
CREATE TABLE <table-name> ( <column-list> [<constraint-list>] ).
Column list with data types and optional and inline constraints.
Optional external constraint list
CONSTRAINT [ ConstraintName ] <Constraint-Spec>
Primary key
Foreign key
Unique
Check
CREATE TABLE Statement Example
CREATE TABLE Student
( StdNo CHAR(11),
StdFirstName VARCHAR(50),
StdLastName VARCHAR(50),
StdCity VARCHAR(50),
StdState CHAR(2),
StdZip CHAR(10),
StdMajor CHAR(6),
StdClass CHAR(6),
StdGPA DECIMAL(3,2) );
Common SQL Data Types:
CHAR(L)
VARCHAR(L)
INTEGER FLOAT(P)
DECIMAL(W, R)
Date/Time: DATE, TIME, TIMESTAMP
BOOLEAN
Our Official Website : Web Conquerors (https://www.webconquerors.com/)
Want to get digital services? Contact US
Want to know about our services? Our Services
Comments
Post a Comment