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.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2005-07-05 : 05:20:06
|
| Hi,I have just joined a Charity organisation as their first and sole dba and have been assessing their databases...its abit of a mess. For one, none of the tables are linked in SQL server, should I be implementing Foreign keys, defaults, etc at database level now even though these are (hopefully!) currently operating somewhere in application code? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-07-05 : 05:33:13
|
| Er yes. How long since these databases went into production? You could have a bit of a problem applying these with the 'WITH CHECK' clause if integrity has not previously been enforced. |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-07-05 : 06:02:17
|
A resounding YES!rockmoose |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-05 : 11:19:47
|
Sounds OK, assuming that the tables actually have real primary keys, and the foreign keys exist in the tables.quote:
Originally posted by chris_wood99...should I be implementing Foreign keys, defaults, etc at database level...
CODO ERGO SUM |
|
|
|
|
|
|
Order to the Chaos!