Add new table column with foreign key

[Admin]

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);