Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1435
| From | "Bob Barrows" <reb01501@NOSPAMyahoo.com> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Elementary management of many indexes, index and statistics names |
| Date | 2013-04-05 12:44 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <kjmv0e$9kc$1@dont-email.me> (permalink) |
| References | <d87de084-20ee-4c81-bc5b-e235f51b6fda@googlegroups.com> |
rja.carnegie@gmail.com wrote: > > I'm also not sure what happens if the table names are these: > > N'[BO-Stud15].[year2011].[ExpectedCostcentre]' > N'[BO-Stud15].[year2012].[ExpectedCostcentre]' > N'[BO-Stud15].[year2013].[ExpectedCostcentre]' > > Can I then use the same primary key name on each of these tables? > Oh wait. I think I found the question :) The answer is: object names within a database need to be unique within that database. Object names can be duplicated in separate databases. This is something you could easily have tested on your own ...
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
Elementary management of many indexes, index and statistics names rja.carnegie@gmail.com - 2013-04-05 07:59 -0700
Re: Elementary management of many indexes, index and statistics names "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2013-04-05 12:36 -0400
Re: Elementary management of many indexes, index and statistics names "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2013-04-05 12:44 -0400
Re: Elementary management of many indexes, index and statistics names Erland Sommarskog <esquel@sommarskog.se> - 2013-04-05 20:28 +0200
Re: Elementary management of many indexes, index and statistics names rja.carnegie@gmail.com - 2013-04-05 15:49 -0700
Re: Elementary management of many indexes, index and statistics names Erland Sommarskog <esquel@sommarskog.se> - 2013-04-06 11:53 +0200
csiph-web