How to add Foreign key in a table after the creation of the
table?
Answer Posted / sagar98
ALTER TABLE <table_name>
ADD CONSTRAINT <fk_name> FOREIGN KEY (column_name)
REFERENCES <table_name_where_this_column_acts_as_PK>
(Column_name)
Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What does bitemporal mean?
What are reports usually used for?
What is cte sql?
What is java sql connection?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Write the command to remove all players named sachin from the players table.
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is multiple columns?
How to change sql*plus system settings?
What are instead of triggers?
what is a primary key? : Sql dba
How do I run a sql trace?
what is the difference between undefined value and null value? : Sql dba
How run sql*plus commands that are stored in a local file?
Is nosql relational?