In my Oracle database connection, I noticed that its showing Schema.tablename, e.g. SDE.Buildings. I created a new SQL Server database and it’s showing up as databasename.schema.tablename, e.g. GIS_TEST.SDE.Buildings.

 

Any idea why that’s happening and is it possible to remove that databasename part from all the table names? It’s just extra noise for no good reason. Or does everyone with SQL Server just have to see that?

 

Thanks,

 

Nicholas McNamara, GISP

UITS: Physical Infrastructure & Planning
University of Connecticut

(860) 486-2515

[log in to unmask]

 

------------------------------------------------------------------------- This list (CTGIS-L) is an unmoderated discussion list for all CT GIS Users.

To change subscription settings or unsubscribe, visit http://s.uconn.edu/ctgisL.