| 
	
		| 
		
			|  | SoftTree Technologies Technical Support Forums
 |  |  
	
		| 
	
	
	
		| Author | Message |  
		| gemisigo 
 
 
 
 
			
				| Joined: 11 Mar 2010 Posts: 2175
 
 |  
 | 
			
				|  [12.4.476 Pro] - Mishandling of aliases in SQL Server |   |  
				| The aliases for tables in SQL Server are not handled correctly. For example, I have a table named Adatblokk_copy which was created using the Clone feature. I have an alias pointing to that table, it is called Adatblokk. The alias was created by this statement:
 
 
	|  |  
	|  | CREATE SYNONYM [dbo].[Adatblokk] FOR [EN_DATABLOCKS].[dbo].[Adatblokk_copy];
 
 |  
 When hovering over the table/alias name in
 
 
	|  |  
	|  | SELECT [whatever] FROM [dbo].[Adatblokk];
 
 |  
 the popup shows this:
 
   
 which is a bit weird (and incorrect).
 
 Also, when I ctrl+click on a column in, eg. the SI:
 
 
	|  |  
	|  | SELECT a.[AdatblokkId], a.[SI] FROM [dbo].[Adatblokk] AS a;
 
 |  
 I get an error:
 
 
	|  |  
	|  | Msg 208, Level 16, State 1,    Invalid object name 'EN_DATABLOCKS.dbo.[dbo].[Adatblokk_copy]'....
 
 |  
 |  |  
		| Tue Apr 09, 2024 2:35 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| Thank you for letting us know. I submitted a bug report for this issue. Tacking ticket number #SA0044513. 
 |  |  
		| Tue Apr 09, 2024 8:31 am |     |  
		|  |  
		| gemisigo 
 
 
 
 
			
				| Joined: 11 Mar 2010 Posts: 2175
 
 |  
 | 
			
				|   |   |  
				| Has there been any progress on this matter? It's still present in 13 beta. 
 |  |  
		| Tue Jul 23, 2024 4:30 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| This seems to be still not fixed. I'm not able to provide an ETA yet. We will address it as soon as possible. 
 |  |  
		| Wed Jul 24, 2024 1:19 pm |     |  
		|  |  
		|  |  
  
	| 
 
 | You cannot post new topics in this forum You cannot reply to topics in this forum
 You cannot edit your posts in this forum
 You cannot delete your posts in this forum
 You cannot vote in polls in this forum
 
 |  |  |