Single Table
This option enables the FROM clause of the seed statement to specify single tables.
A FROM clause can include a sequence of single table references, which creates an implicit inner join.
A FROM clause in a seed statement cannot specify the name of the WITH RECURSIVE query.
Syntax Element … |
Specifies … |
table_name |
the name of a single table, derived table, table UDF, or view referred to in the FROM clause. |
AS |
an optional introduction to correlation_name. |
correlation_name |
an alias for the table referenced in the FROM clause. |