answersLogoWhite

0

How do you link two tables?

User Avatar

Anonymous

12y ago
Updated: 8/20/2019

Tables are linked through the use of a foreign key, such as with the following command:

Alter Table MyTable Add Foreign Key (MyOtherTableId) References MyOtherTable(Id);

MyOtherTableId must already be an existing field on MyTable, MyOtherTable must already be another table, Id must exist in MyOtherTable, and MyOtherTableId and Id must share a compatible data type.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What does primary key mean in ict?

it key that will enable you link the two tables together for relationship


What data sources can be linked to in Access?

You can link excel tables, text files, access tables, ODBC tables


Which part of a relational database contains the logical structure for the information?

The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.The tables do. There must be at least two of them for a relational database.


In relational database when two tables have common field the link between tables is know as a hyperlink?

Actually, in a relational database, when two tables have a common field, the relationship between the tables is known as a foreign key constraint. This constraint ensures that values in the common field of one table correspond to values in another table, helping maintain data integrity and enabling queries across related tables.


What are two kinds of data tables that can be created?

one- input tables and three input tables


Where do you download kcse 2010 knec time tables?

Download KCSE KCPE time tables at the related link below.


Which two tables contain label information?

LFIB and LIB tables


How do you convert Ms-word to Excel?

You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.


What do periodic tables look like?

See related link below.


Where to find unit conversion tables?

For example see the link below.


How can centriole compare to a restaurant?

as two tables together an when two people are arriving wanting seperate tables they seperate!


Is tables a plural?

Yes, as it has an s on the end. One table. Two tables.