How to name set foreign key reference add alter

Question

create a table in primary key not set name but table alter use foreign key set name SQL QUERY SEND

Tapan Patel · Answer

As you created FKey, it would have some sys defined name, so this is what you can do. sp_rename 'schema.ExistingForeignkeyConstraintName' , 'newNameOfConstraints' ,N 'OBJECT'

Nilesh Shah · Answer

you need to ask your question preperly I don't understand what you want to ask

Mukil Vendhan · Answer

kindly follow the link:https://www.w3schools.com/sql/sql_foreignkey.asp

Mukil Vendhan · Answer

kindly follow CREATE TABLE table_name ( column1 datatype null / not null , column2 datatype null / not null , ... CONSTRAINT fk_column FOREIGN KEY (column1, column2, ... column_n) REFERENCES parent_table (column1, column2, ... column_n) ); the link:https://www.techonthenet.com/oracle/foreign_keys/foreign_keys.php

Anil Jha · Answer

If you are creating table, then use below sql CREATE TABLE Orders ( OrderID int NOT NULL , OrderNumber int NOT NULL , PersonID int , PRIMARY KEY (OrderID), CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) ); If you want to add foreign key in your existing table, then use below sql. ALTER TABLE Orders ADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID); OR If you want to give name to your foreign key, then use below sql. ALTER TABLE Orders ADD CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

Manas Mohapatra · Answer

Did you try like this: ALTER TABLE Tablename ADD FOREIGN KEY (ForeignKeyColumnId) REFERENCES OtherTable( PrimaryKeyColumnId )

How to name set foreign key reference add alter

Answers (6)