Ajude a Asast
Patrocinadores
Últimos assuntos
» Novo site para desportistas / New site for athletes
Add new table column with foreign key EmptyTer Dez 04, 2018 8:19 am por Admin

» Check used port with the command line
Add new table column with foreign key EmptyTer Dez 04, 2018 8:10 am por Admin

» Check the port where mariaDB is running
Add new table column with foreign key EmptySeg Dez 03, 2018 4:59 am por Admin

» Check the linux version
Add new table column with foreign key EmptySeg Dez 03, 2018 3:12 am por Admin

» Granting rights to a database for a user
Add new table column with foreign key EmptyQui Nov 29, 2018 2:04 am por Admin

» Create new user
Add new table column with foreign key EmptyQui Nov 29, 2018 2:01 am por Admin

» Change level of password security level
Add new table column with foreign key EmptyQui Nov 29, 2018 1:59 am por Admin

» reactJS - A JavaScript library for building user interfaces
Add new table column with foreign key EmptyQua Out 24, 2018 3:02 am por Admin

» Count number of lines in all files existing
Add new table column with foreign key EmptyQui Jun 28, 2018 4:53 am por Admin

AdSense
Contributo

Add new table column with foreign key

Ir em baixo

Add new table column with foreign key Empty Add new table column with foreign key

Mensagem  Admin em Sex Maio 22, 2015 7:08 am

Código:


ALTER TABLE TABLE_NAME
ADD COLUMN COLUMN_NAME TYPE,
ADD CONSTRAINT FK_TABLE_COLUMN_NAME FOREIGN KEY (COLUMN_NAME)
REFERENCES REFERENCE_TABLE(REFERENCE_COLUMN);

Admin
Admin
Admin

Mensagens : 607
Data de inscrição : 21/01/2008
Idade : 41

Ver perfil do usuário http://forum-informatico.forumeiros.com

Voltar ao Topo Ir em baixo

Voltar ao Topo


 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum