The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected to those databases using EXCEL and have had to link several tables to garner the information that I need. I have created 2 of the many tables I'm going to need for a Sales and Inventory program I'm trying to build. I know that these two table will need to be linked via "keys".
My questions are:
1) Can you create multiple keys within a database table? If so, how is this done? It is my belief that I will need these multiple keys to allow 1 database to link with several different databases.
2) When creating these keys, how is it you decide which is is to be "Primary"?
3) When setting up the "column" for the key, what "Data Type" is used?
4) Are these keys meant to hold data? If so, what kind of data?
Forgive my ignorance on this subject. In the classes I've taken on Visual Basic, we did touch on databases but didn't spend anywhere near enough time on the details. More specifically, we didn't discuss how to setup database tables. I really am a "newbie" but I'm really enjoying the learning. I've garnered so much information for this forum and really appreciate all who have contributed.
I look forward to hearing from each of you.