Simples comandos SQL

June 3, 2017 | Autor: Carlos Jaime Robles | Categoría: Information Systems, Database Systems, Databases
Share Embed


Descripción

create table Estudiante(carne varchar(35) not null primary key, cedula varchar(35) not null, nombres varchar(50), apellidos varchar(50), direccion varchar(100), fechaNac date, email varchar(30), paisNac integer not null, departNac integer not null, municNac integer not null); alter table Estudiante add constraint unCedula unique (cedula);-tabla pais create table Pais(id_pais integer not null primary key, pais varchar(25) not null); alter table Pais add constraint uc_idPais unique (id_pais); create sequence secPais start with 1 increment by 1; create table Departamento(id_depart integer not null primary key, id_pais integer, departamento varchar(35) not null); create sequence secDepart start with 1 increment by 1; alter table Departamento add constraint un_departamento unique (departamento);-Municipio create table Municipio (id_municipio integer not null primary key, id_depart integer not mull,
Lihat lebih banyak...

Comentarios

Copyright © 2017 DATOSPDF Inc.