Creating and destroying base tables, PL-SQL Programming

Creating and Destroying Base Tables:

Example shows an SQL command to create the base table counterpart of the ENROLMENT variable

Example  Creating a base table.

CREATE TABLE ENROLMENT
( StudentId  SID ,
  Name   VARCHAR(30),
  CourseId  CID ,
  PRIMARY KEY ( StudentId, CourseId )
) ;

(Example and the other examples in this chapter all end in semicolons. Actually, a semicolon is required in SQL only in scripts consisting of more than one statement. A script consisting of a single statement must not end in a semicolon.)

Posted Date: 1/11/2013 5:20:19 AM | Location : United States







Related Discussions:- Creating and destroying base tables, Assignment Help, Ask Question on Creating and destroying base tables, Get Answer, Expert's Help, Creating and destroying base tables Discussions

Write discussion on Creating and destroying base tables
Your posts are moderated
Related Questions
Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw