Groups > comp.databases.ms-sqlserver > #1435

Re: Elementary management of many indexes, index and statistics names

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Elementary management of many indexes, index and statistics names
Date	Fri, 5 Apr 2013 12:44:43 -0400
Organization	A noiseless patient Spider
Lines	16
Message-ID	<kjmv0e$9kc$1@dont-email.me> (permalink)
References	<d87de084-20ee-4c81-bc5b-e235f51b6fda@googlegroups.com>
Injection-Date	Fri, 5 Apr 2013 16:43:59 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="50beab819512ecf851135963dd46e402"; logging-data="9868"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18BNzPtcWv7+N7YaUSylqamGccxx/M2tTE="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646	Format=Flowed; Original
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
Cancel-Lock	sha1:d0jnsTOgrbfPuRdltKz6hAevyMA=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1435

Show key headers only | View raw

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

Thread

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