Use of this site constitutes acceptance of our User Agreement (effective 1/2/2014) and Privacy Policy (effective 1/2/2014). Golf Digest may earn a portion of sales from products that are purchased through our site as part of our Affiliate Partnerships with retailers. Your California Privacy Rights The material on this site may not be reproduced, distributed, transmitted, cached or otherwise used, except with the prior written permission of CondÃ© Nast.
Temp table: A Temp table is easy to create and back up data. Table variable: But the table variable involves the effort when we usually create the normal tables. Temp table: Temp table result can be used by multiple users. Table variable: But the table variable can be used by the current user only.
The TABLES table provides information about tables in databases. Notes: Refer to SHOW TABLE STATUS for field descriptions. TABLE_SCHEMA and TABLE_NAME are a single field in a SHOW display, for example Table_in_db1. TABLE_TYPE should be BASE TABLE or VIEW. The TABLES table does not list TEMPORARY tables. For partitioned tables, the ENGINE column shows the name of the storage engine used by all partitions. The TABLE_ROWS column is NULL if the table is in the INFORMATION_SCHEMA database. For InnoDB tables, the row count is only a rough estimate used in SQL optimization.