Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> 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?
 
Yes, you can, since these tables are in different schemas.

Whether you should is a different matter. If you are generating all this stuff, creating unique names for all indexes, keys or not, is a no-brainer.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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