Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Técnico Superior en Computación

No description
by

Liz Gi Oviedo Luna

on 18 November 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Técnico Superior en Computación

BASE DE DATOS
CREATE VIEW
CREATE VIEW
nombre_vista
[ (columna ,... ) ]
AS
sentencia_select
[
WITH CHECK OPTION
]
PROCEDIMIENTOS
INSERT
CREATE TABLE
CREATE TABLE
nombre_tabla
(
{ <definicion_columna>
| [ <restriccion_tabla> ] } ,... ) ;

DEFinición de COLUMNA
nom_col tipoDato [
NULL
|
NOT NULL
]
[[
CONSTRAINT
nom_restr ]
DEFAULT
const_expr ]
| [
IDENTITY
[ ( base ,incremento ) ] ]
[
ROWGUIDCOL
]
[[
CONSTRAINT
nom_restr ]
{ {
PRIMARY KEY
|
UNIQUE
}
| [
FOREIGN KEY
]
REFERENCES
tabla_ref [ ( col_ref ) ]
[
ON DELETE
{
NO ACTION
|
CASCADE
|
SET NULL
|
SET DEFAULT
} ]
[
ON UPDATE
{
NO ACTION
|
CASCADE
|
SET NULL
|
SET DEFAULT
} ]
|
CHECK
( expr_logica ) ] }
ALTER TABLE
Restricción Tabla
[
CONSTRAINT
nom_restr ]
{{
PRIMARY KEY
|
UNIQUE
}
(column [ ASC | DESC ] ,...)
|
FOREIGN KEY
( column ,... )

REFERENCES
table_ref [( col_ref ,... ) ]
[
ON DELETE
{ NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]
[
ON UPDATE
{ NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]
|
CHECK
( expr_logica ) }
ALTER TABLE
nom_tabla
{
ALTER COLUMN
nom_col
tipoDato [
NULL
|
NOT NULL
]
|
ADD
{ <def_columna>
| <restriccion_tabla> } ,...
|
DROP
{
CONSTRAINT
nom_restr ,...
|
COLUMN
nom_col,... }
,...}
DROP TABLE
DROP TABLE
nombre_tabla ,...
LMD
LDD
INSERT
[ TOP ( expr ) [ PERCENT ] ]
INTO
nom_tabla
[(lista_col)]
{
VALUES
({
DEFAULT
|
NULL
|expr},...),...
| sentencia_SELECT
|
DEFAULT VALUES
}
UPDATE
UPDATE
[
TOP
(expr) [
PERCENT
]]
nom_tabla
SET
{Col_nombre = {expr |
DEFAULT
|
NULL
}
| Col_nombre
{+ = | - = | * = | / = |% = | y = | ^ = | | =}
expr} , ...
[
FROM
table_origen]
[
WHERE
<condicion>]
DELETE
DELETE
[
TOP
(expr)[
PERCENT
]]
FROM
tabla
[
FROM
tabla_origen,... ]
[
WHERE
<condicion> ]
VISTA
ALTER VIEW
nombre_vista
[ (columna ,... ) ]
AS
sentencia_select
[
WITH CHECK OPTION
]
DROP VIEW
DROP VIEW
nombre_vista,...
Store Procedure
TRIGGER
CREATE PROCEDURE
nom_proc
[@par tipoDato[= default]
[OUT|OUTPUT],...
AS
[
BEGIN
]
sentencia_sql;...
[
END
]

CREATE TRIGGER
nom_trig
ON
{table|view}
{
FOR
|
AFTER
|
INSTEAD OF
}
{[
INSERT
][,][
UPDATE
][,][
DELETE
]}
AS
sentencia_sql ;...
Técnico Superior en Computación
Orientación Administrativa
Escuela Superior de Comercio - UNS
Prof. Oviedo, Elizabeth Gisela
BASE DE DATOS
ALTER VIEW
Full transcript