@Rocky how to check table name when I have table id on 4.0.10 share-nothing

To find a table name using its Table ID in a StarRocks shared-nothing cluster, you can use the

information_schema.tables_config

system table. This is the most direct way to map an ID to a name across the entire cluster. Method 1: Using

information_schema.tables_config

(Recommended) Run the following SQL query:

sql
SELECT table_schema, table_name 
FROM information_schema.tables_config 
WHERE table_id = <your_table_id>;

Method 2: Using

SHOW PROC

If you know which database the table belongs to, you can use the

SHOW PROC

command. This is often used for administrative troubleshooting: 1. Find the Database ID (if you only have the Table ID and need to browse):

sql
   SHOW PROC '/dbs';

2. List tables in that database:

sql
   SHOW PROC '/dbs/<db_id>';
   -- OR --
   SHOW PROC '/dbs/<database_name>';

The output will display a column

TableId

alongside

TableName

. Note on Version 4.0.10 While the current stable releases of StarRocks are in the 3.x series, the

information_schema.tables_config

table is the standard metadata source for table IDs in modern StarRocks architectures and remains the reliable method for identifying tables in shared-nothing deployments. References • deployment/shared_data/azure.md • deployment/shared_data/s3.md • deployment/shared_data/minio.md • deployment/shared_data/hdfs.md • faq/shared_data_faq.md • sql-reference/information_schema/tables_config.md • deployment/shared_data/gcs.md