Answer Posted / purushotham

we can add a foreign key to a table
1)while creation of table
2)After the creation of the table

by using
Alter table table_name add foreign key(column_name)
References column_name from table_name(that consists of
primary key)

What is localdb mssqllocaldb?

1017

---

What is a schema sql?

1052

---

Is like operator in sql case sensitive?

960

---

what is the difference between a having clause and a where clause? : Sql dba

1006

---

what is auto increment? : Sql dba

963

---

What is the maximum size of sqlite database?

1039

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

892

---

What are literals in sql server?

1070

---

How many indexes can be created on a table in sql?

984

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

953

---

List the different type of joins?

999

---

What are the two virtual tables available at the time of database trigger execution?

1156

---

How do I remove sql plus from windows 10?

1022

---

Which data type is a composite type?

931

---

how can we know the number of days between two given dates using mysql? : Sql dba

990

---