base table

The view (and its accompanying index, if it is an indexed view) can be copied to the Subscriber, but the base table must also be replicated.

The result set returned by a pass-through query can be used in the FROM clause of a query like an ordinary base table.

In these cases, the trigger can be coded to use alternative sources of information to determine the values to set in the base table columns.

Base table fields have been changed and no longer match view fields. View field properties cannot be set.

The row set request may be in the form of executing a query against the provider or opening a base table from the provider .

The select list of a view can also contain expressions that do not directly map to a single base-table column.

When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition.

Can be the same as the name of a base table or view.

Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly.

If the query optimizer decides to use an indexed view in a query plan, the indexed view is treated the same way as a base table.

An UPDATE statement referencing a table or view can change the data in only one base table at a time.

A column in a view does not automatically have the same properties as the column in the base table.

To do this, the INSTEAD OF UPDATE trigger must not try to update the values for the corresponding columns in the base table.

External tables can be created with the columns of all the data types supported by the regular base table in IDS.

As the data for the base table(s) changes, the MQT needs to be updated accordingly.

The SQL statement to execute or the name of the base table to open.

For this type of article, the base table does not need to be published separately.

Nonclustered indexes do not have to be scanned to validate the base table.

These issues also apply to view columns that are simple expressions referencing a computed column in a base table.

This procedure migrates the data from each remote table into the base table created by the sa_migrate_create_tables procedure.

The columns changed by the UPDATE must be resolved to a single base table.

An index is an ordered set of pointers to rows in a base table.

Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.

API cursor query contains an indexed view with a unique access path, but not at the base-table level.

This set of columns may be generated from a base table primary key, a unique constraint or a unique index.

The view referenced by table_or_view_name must be updatable and reference exactly one base table in the FROM clause of the view.

However, the design of an MQT can be affected by which partitioning features are used on the base table.

Creates a secondary XML index on columns (PK, path and node value) of the primary XML index where PK is the primary key of the base table.

Each modification to an underlying base table starts the chain of applying constraints and firing AFTER triggers defined for the table.

XML indexes use the same partitioning scheme and partitioning function of the base table.

The column ID of a base table should be invariant under views.

The wizard automatically detects the column definitions of the base table being indexed.

For this type of article, the base table must also be published.

When querying a view, only one full-text indexed base table can be involved.

Each column in the inserted and deleted tables maps directly to a column in the base table.

A null value if the base table name cannot be determined.

Number of unrestricted full scans. These can either be base table or full index scans.

A convenient solution is to use a base table with columns for the MobiLink user name and other session data.

The INSTEAD OF trigger can ignore the value supplied when it forms the INSERT statement that inserts the values into the base table.

Specify NULL to return information for all indexes for a base table or view.

Generates number for local changes to the base table of an article.

The generate number for local changes to the base table of an article.

Base cardinality is the number of rows in a base table.

Access to the data could then be governed through the view, instead of the base table.

Null values returned from a base table are also difficult to distinguish from the null values returned from an outer join.

The base table will have rows representing concurrent synchronizations.

The primary key of the base table is duplicated in the property table for back join.

Only views in which all columns refer to the same base table can be used.

The base table structure is not dependent on the structure of a nonclustered index.

If the base table is partitioned, the XML index uses the same partition scheme as the table.

View expressions that transform the value of a single base table column, such as referencing a column in a function.

The following example opens a base table and uses an index to quickly retrieve values from the specified range.

A probe scan is used to directly look up rows in an index or base table.

An index or primary key must be defined in the base table.

In general, Microsoft SQL Server 2005 must be able to unambiguously trace modifications from the view definition to one base table.

Defragment the index of the base table by using ALTER INDEX REORGANIZE.

In addition, the page counts for each index are tracked separately and are not aggregated for the base table.

Any column in the base table can be specified.

The use of partitioning features on the base table does not need to take into account whether MQTs will be built upon this table.

Identity columns in the base table for which IDENTITY INSERT is set to OFF.

Identity columns in the base table for which IDENTITY INSERT is OFF.

Update the statistics of the base table by using the UPDATE STATISTICS statement.

The primary key is used to correlate index rows with the rows in the base table.

Base table columns with the timestamp data type.

The column can contain duplicate values in the base table.

Because the column ScrapReasonID is an IDENTITY column in the base table, the trigger ignores the user-supplied value.

The second ON phrase is used to join the table expression (sales_order JOIN customer) to the base table sales_order_item.

Sp_helpmergeconflictrows returns a result set consisting of the base table structure and these additional columns.

Base table cursors can be opened only by using IOpenRowset: : OpenRowset.

Just like a base table, a result set from a SELECT query has columns and rows.

The storage engine uses prefetching to speed base table lookups from nonclustered indexes.

Therefore, they reside in both the index and the base table.

The statement must reference a base table.

DB2 10 also removes restrictions on the online reorganization of base table spaces that use LOB columns.

Retrieving rows from an index using the IndexName property will retrieve all rows from a base table in index order.

Name of the table article being joined to the base table.

Name of the owner of the table being joined to the base table.

Name of schema that contains the base table.

Computed columns in the base table.

SQL Server does not default to scanning the base table into SQL Server and performing the relational operations itself.

Primary key of the base table.

Name of the owner of the base table.

Name of the table being joined to the base table.

Updates are not allowed if a base table contains a timestamp column.

A nonpartitioned clustered index and the base table always reside in the same filegroup.

When using this option , you must also publish the base table .

Name of the database that contains the base table that is supplying the column.

ID of the database that contains the base table that is supplying the column.

Name of the base table.

Object ID of the object or base table that is supplying the column.

A select-list item that is not a base table.

Base table that the view is based on.

If column tracking is used, the base table can include a maximum of 246 columns.

Microsoft SQL Server 2005 Compact Edition supports the base table, forward-only, and scrollable cursor types.

Each SELECT statement references one SQL Server base table.

DB2 V9. 5 introduces base table row storage of XML data.

However, DB2 will optimize the re-computation as best it can, such as by scanning the summary table instead of the entire base table.

In earlier versions of SQL Server, the nonclustered index and the base table in the other filegroup are checked.

From an early age to study hard, wide base table book, so knowledgeable, engineering poetry, good painting and calligraphy.

Generally, the Database Engine must be able to unambiguously trace modifications from the view definition to one base table.

Before an existing base table can be added (attached) to a partitioned table, the following conditions must be met

The Database Engine first scans the data pages of the base table to retrieve key values and builds an index leaf row for each data row.

You can modify the data of an underlying base table through a view, as long as the following conditions are true

References to any base table column that allows nulls

Views can contain expressions in their select list that do not map to any base table columns, for example

Views are similar to the permanent tables of the database (a permanent table is also called a base table) in many ways

Any column in the base table can be specified, except when partitioning a UNIQUE index,

This includes view columns that reference columns in the base table for which input values cannot be specified, such as

While loading, if the target base table is fragmented, the load happens in parallel under the PDQ environment

Clause specifies only one base table, all column names in the

Is reading columns from more than one base table,

Aggregations or computations based on data from base table(s)

SQL Server cannot trace this column directly to its base table,

Unload the data from the customer base table using the query in Listing 9

Query ON base TABLE executes USING INDEX AND it IS very fast