May be a database with a name dboor a schema with a name dbo.dboor a table with a name dbo.tablename.
These commands are valid:
create database dbo
use dbo
create schema [dbo.dbo]
create table [dbo.dbo].[dbo.tablename] (id int, name varchar(10))
select * from [dbo.dbo].[dbo.tablename] as dt
select * from dbo.[dbo.dbo].[dbo.tablename] as dt
This definitely negatively affects the fact that it is not clear enough for programmers who subsequently have to read this source code.
source
share