Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Relational Database

Author  Topic 

jsc0624
Starting Member

13 Posts

Posted - 2007-04-26 : 02:19:13
If I have a table that contains default values or a constant values do I have to relate it to my other tables that might need them. Thanks in advance.

===============
JSC0624
===============

maevr
Posting Yak Master

169 Posts

Posted - 2007-04-26 : 02:37:33
Hi
Can you please give som example of how you want to use your data. If you have a table containing Employees and another containing Managers then you should use primary and foreign keys on the tables to relate them to each others.

Perhaps this is not tha answer you want but then u have to give example of expected output and table information
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2007-04-26 : 19:49:52
Sounds like you are talking about an INI file type of thing. You don't usually need to relate it but it can be useful (e.g. a default country code should be related to the master country table).
Go to Top of Page
   

- Advertisement -