Skip to content

Commit fc927dc

Browse files
Update from-transact-sql.md
changed "requires" to "may require" for table_alias definition, because it is not required to full qualify column names etc select * from sys.columns, sys.tables works just define, while bot tables contains columns like object_id, name and so on
1 parent 9864162 commit fc927dc

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/queries/from-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -185,7 +185,7 @@ FROM { <table_source> [ ,...n ] }
185185
If the table or view exists outside the instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]l, use a four-part name in the form *linked_server*.*catalog*.*schema*.*object*. For more information, see [sp_addlinkedserver &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql.md). A four-part name that is constructed by using the [OPENDATASOURCE](../../t-sql/functions/opendatasource-transact-sql.md) function as the server part of the name can also be used to specify the remote table source. When OPENDATASOURCE is specified, *database_name* and *schema_name* may not apply to all data sources and is subject to the capabilities of the OLE DB provider that accesses the remote object.
186186

187187
[AS] *table_alias*
188-
Is an alias for *table_source* that can be used either for convenience or to distinguish a table or view in a self-join or subquery. An alias is frequently a shortened table name used to refer to specific columns of the tables in a join. If the same column name exists in more than one table in the join, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] requires that the column name be qualified by a table name, view name, or alias. The table name cannot be used if an alias is defined.
188+
Is an alias for *table_source* that can be used either for convenience or to distinguish a table or view in a self-join or subquery. An alias is frequently a shortened table name used to refer to specific columns of the tables in a join. If the same column name exists in more than one table in the join, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] may require that the column name be qualified by a table name, view name, or alias to distinguish these columns. The table name cannot be used if an alias is defined.
189189

190190
When a derived table, rowset or table-valued function, or operator clause (such as PIVOT or UNPIVOT) is used, the required *table_alias* at the end of the clause is the associated table name for all columns, including grouping columns, returned.
191191

0 commit comments

Comments
 (0)