SQL dot notation

by

This is a database schema. Full three-part name of a table is:

databasename.schemaname.tablename

For a default schema of the user, you can also omit the schema name:

databasename..tablename

You can also specify a linked server name:

servername.databasename.schemaname.tablename

You can read more about using identifiers as table names on MSDN:

The server, database, and owner names are known as the qualifiers of the object name. When you refer to an object, you do not have to specify the server, database, and owner. The qualifiers can be omitted by marking their positions with a period. The valid forms of object names include the following:

server_name.database_name.schema_name.object_name

server_name.database_name..object_name

server_name..schema_name.object_name

server_name…object_name

database_name.schema_name.object_name

database_name..object_name

schema_name.object_name

object_name

An object name that specifies all four parts is known as a fully qualified name. Each object that is created in Microsoft SQL Server must have a unique, fully qualified name. For example, there can be two tables named xyz in the same database if they have different owners.

Most object references use three-part names. The default server_name is the local server. The default database_name is the current database of the connection. The default schema_name is the default schema of the user submitting the statement. Unless otherwise configured, the default schema of new users is the dbo schema.

More Related Contents:

  1. How do I perform a GROUP BY on an aliased column in SQL Server?
  2. Curly braces in T-SQL
  3. Syntax of for-loop in SQL Server
  4. Subquery using Exists 1 or Exists *
  5. Truncate (not round) decimal places in SQL Server
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. Update records in table from CTE
  8. Dynamic Pivot Columns in SQL Server
  9. Is it possible to select sql server data using column ordinal position
  10. Selecting N rows in SQL Server
  11. how can I Update top 100 records in sql server
  12. How can I INSERT data into two tables simultaneously in SQL Server?
  13. SQL “select where not in subquery” returns no results
  14. How can a LEFT OUTER JOIN return more records than exist in the left table?
  15. Count Number of Consecutive Occurrence of values in Table
  16. Dynamic SQL to generate column names?
  17. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  18. Calculate the number of records for each date between 2 dates
  19. T-SQL: How to use parameters in dynamic SQL?
  20. Get the records of last month in SQL server
  21. How to compare datetime with only date in SQL Server
  22. Merge overlapping date intervals
  23. SQL server select distinct rows using most recent value only
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. alternatives to REPLACE on a text or ntext datatype
  26. Split words with a capital letter in sql
  27. SQL poor stored procedure execution plan performance – parameter sniffing
  28. Eliminate and reduce overlapping date ranges
  29. scope_identity vs ident_current
  30. Convert bigint to datetime

Leave a Comment