# `Sp_CopyTableToTable` (procedure)

> 根据表名称将表数据拷贝到另一张表


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sTableName` | `varchar(50)` |
| 2 | IN | `sSrcTableName` | `varchar(50)` |
| 3 | IN | `sDbName` | `varchar(50)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_CopyTableToTable`'`._

## Narrative

**Business context:** 系统平台 → 数据维护工具 — generic "copy one table's rows into another table" helper. Aligns the column lists by name (only the columns that exist in both `sTableName` and `sSrcTableName` under schema `sDbName` are copied), so it can mirror data across upgraded or branched tables without breaking on schema drift.

**What it does:** Counts columns of the target `sTableName` from `information_schema.COLUMNS`, opens a cursor over them, and for each column checks whether the same name exists on `sSrcTableName`; if so, appends it to `p_sColumnsList`. Then builds and `PREPARE`/`EXECUTE`s `INSERT INTO sTableName(<list>) SELECT <list> FROM sSrcTableName`. No filter, no transaction — full table copy.

**Invocation:** Status: appears orphaned. No `gdsmodule` hook, `gdsconfigformmaster` reference, or other-routine caller; xly-src only ships the install script `script/标版/30100101/Sp_CopyTableToTable.sql`. Generic data-tool intended to be called interactively during migrations/maintenance, not from runtime traffic.