Primary key - sql, PL-SQL Programming

Primary Key - SQL

A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the key word UNIQUE must be used in place of PRIMARY KEY for all or all but one of them. A UNIQUE specification does not carry an implicit NOT NULL constraint on each column of the specified key (says the SQL standard, though I am aware of at least one SQL implementation where it does).

Whether declared using PRIMARY KEY or UNIQUE, at least one column must be specified.

Posted Date: 1/18/2013 7:51:31 AM | Location : United States

Related Discussions:- Primary key - sql, Assignment Help, Ask Question on Primary key - sql, Get Answer, Expert's Help, Primary key - sql Discussions

Write discussion on Primary key - sql
Your posts are moderated
Related Questions
Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

"Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (