No announcements
Found 3404574 threads
-
0 VotesForeign Keys for Documentation Purposes
Hello, Our conplete DW is filled by SSIS and some SP. They all do their job fine and for speed purposes we didn't define foreign ...Answered | 1 Replies | 854 Views | Created by Kinepolis - Tuesday, May 3, 2016 7:07 PM | Last reply by Alberto Morillo - Tuesday, May 3, 2016 7:38 PM
-
0 Votes
Using Workflows for documentation purposes
available space, so it is not readable in print outs b) You can only see the name in the symbol, for documentation purposes, also the "most ...Answered | 2 Replies | 3169 Views | Created by Dominik Mauchle - Friday, September 1, 2006 9:35 AM | Last reply by S Nesbitt - Friday, September 1, 2006 10:34 PM -
0 Votes
Class designer for Documentation purposes...
Hi Paul,Thanks for your feedback. There are plans for providing support for database diagrams etc (based around the DSL technology that Class Designer is builtAnswered | 1 Replies | 6937 Views | Created by Paul Domag - Saturday, July 16, 2005 4:01 PM | Last reply by Ramesh Rajagopal - MSFT - Monday, July 18, 2005 2:59 PM -
0 Votes
Null value for foreign keys
User818889995 posted It is going to be tough if you Foreign Key is referencing a Primary Key. Values for Foreign key columns should be ...Answered | 1 Replies | 5 Views | Created by Anonymous - Tuesday, October 7, 2008 7:06 AM | Last reply by Anonymous - Tuesday, October 7, 2008 9:29 AM -
0 Votes
index for foreign keys
can. In the EF 4 beta timeframe I noticed that their database generation T4 template didn't include indexes for foreign keys, so I sent them an updated ...Answered | 4 Replies | 2943 Views | Created by msloy - Monday, May 13, 2013 9:43 PM | Last reply by davidbaxterbrowne - Tuesday, May 14, 2013 12:09 AM -
1 Votes
Foreign keys
Dear friends, I have table with many Foreign keys. Are there some tools to finding Primary Keys (and table from which come) for this ...Answered | 9 Replies | 548 Views | Created by Anna1313 - Wednesday, March 9, 2016 12:44 PM | Last reply by Anna1313 - Wednesday, March 9, 2016 2:19 PM -
0 Votes
Foreign keys and performance.
performance tests for this. To simplify my tests I would like to have a function that will remove/disable all foreign keys in whole selected database – is it possible ...Answered | 1 Replies | 2651 Views | Created by kicaj - Thursday, September 20, 2012 6:07 PM | Last reply by Naarasimha - Thursday, September 20, 2012 7:03 PM -
0 Votes
Foreign Keys
I have created a 2 tables and was wondering if I could have 2 foreign keys in one table? Trying to enter grocery receipts and then get a report for ...Answered | 3 Replies | 399 Views | Created by Exceluser367 - Tuesday, October 6, 2015 8:29 PM | Last reply by Ken Sheridan - Wednesday, October 7, 2015 10:19 PM -
0 Votes
unindexed foreign keys
User-821857111 posted Generally, you should index foreign keys that are used in WHERE clauses and in joins. That usually covers most, if not all foreign ...Answered | 1 Replies | 26 Views | Created by Anonymous - Thursday, September 1, 2016 6:03 PM | Last reply by Anonymous - Thursday, September 1, 2016 8:03 PM -
0 Votes
Foreign Keys
User-1786411686 posted sp_help 'yourTable' tells you all the tables 'yourTable' is foreign keyed to and also other tables that reference 'yourTable.Answered | 2 Replies | 18 Views | Created by Anonymous - Tuesday, April 17, 2007 6:32 AM | Last reply by Anonymous - Tuesday, April 17, 2007 12:04 PM -
0 Votes
Foreign Keys
with a foreign key and I am going to use a gridview to display certain things from table A, but table A contains a foreign key INT to table B. I want to be able to display ...Answered | 2 Replies | 15 Views | Created by Anonymous - Friday, August 14, 2009 4:23 PM | Last reply by Anonymous - Friday, August 14, 2009 4:54 PM -
0 Votes
Foreign keys
Hi, In the current CTP, we do not support tables with self-references. We will support these scenarios in the final release. For now, you can work ...Answered | 1 Replies | 6596 Views | Created by overthetop - Tuesday, September 5, 2006 1:42 PM | Last reply by Colin Meek - Monday, September 11, 2006 10:21 PM -
0 Votes
Creating foreign keys
Hello, I add the foreign keys on the server side in the GetSchema method to the SyncSchema.Tables[n].ForeignKeys collection. When handling the CreatingSchema event ...Answered | 2 Replies | 10012 Views | Created by Dick_ - Monday, May 4, 2009 7:33 PM | Last reply by Dick_ - Tuesday, May 5, 2009 7:53 AM -
0 Votes
Foreign Keys on Views
view would be the best solution I found. And one short second question. Would it reasonable to use a view as fact table (what is of course not possible, if I cannot define ...Answered | 1 Replies | 3758 Views | Created by Martin Brehm - Monday, June 8, 2009 9:00 AM | Last reply by Martin Brehm - Monday, June 8, 2009 9:20 AM -
0 Votes
Foreign Keys
1. open the enterprise manager. extend the dropdown to the database 2. doble clcik the database and open the database diagram for ...Answered | 1 Replies | 6705 Views | Created by crazyabtdotnet - Wednesday, October 11, 2006 3:38 PM | Last reply by JoeyDj - Wednesday, October 11, 2006 9:40 PM -
0 Votes
No foreign keys found
That's it, it works! Thank you Jerry, for helping me. I have to admit I don't see why not saving a password allows me to list tables but not ...Answered | 2 Replies | 3372 Views | Created by Stefan_A - Friday, January 29, 2010 11:04 AM | Last reply by Stefan_A - Monday, February 1, 2010 8:20 AM -
0 Votes
Primary Key, foreign keys
foreign keys in a table. Please check it again you are possible doing something wrong if you are using SQL Server Management Studio If you are using SQL DDL ...Answered | 5 Replies | 47 Views | Created by Anonymous - Sunday, January 12, 2014 4:01 PM | Last reply by Anonymous - Tuesday, January 14, 2014 1:24 AM -
1 Votes
Foreign Primary Keys
foreign object before saving the main object. This is not the tidiest of methods, and why I may end up using all generated IDs as primary keys rather than compound ...Answered | 2 Replies | 3659 Views | Created by AdamSTL - Sunday, December 14, 2008 10:24 PM | Last reply by AdamSTL - Wednesday, December 31, 2008 12:22 PM -
0 Votes
"Orphaned" Foreign Keys
My error. Scripting error on my part. Many of these foreign keys need to be re-evaluated as they are now obsolete, however they are not orphaned. I need more ...Answered | 2 Replies | 1127 Views | Created by CZilligen - Wednesday, December 3, 2014 10:13 PM | Last reply by CZilligen - Wednesday, December 3, 2014 11:30 PM -
0 Votes
Foreign Keys
Hi, I am having an Issue related to displaying my foreign keys on screens. I have two tables in a Microsoft SQL database linked by ...Answered | 3 Replies | 832 Views | Created by CylusOmally - Tuesday, September 24, 2013 8:09 PM | Last reply by Xpert360 - Wednesday, September 25, 2013 1:32 PM - Items 1 to 20 of 3404574 Next ›
No announcements
