Skip to Content
0
Jun 28, 2020 at 10:10 AM

The doubt of the table_name written format in \dc

91 Views

How to explain the following phenomenon with \dc <table_name> ?

select * from "LIUYL_BAK"."baktest1_catlog";

| BACKUP_ID | DESTINATION_PATH | | -------------------- |

| 1592362328179 | /usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_2_1 |

| 1592362328179 | /usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_3_1 |

| 1592362328179 | /usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_0_1 |

3 rows selected (overall time 1704.078 msec; server time 1013 usec)

\dc "LIUYL_BAK"."baktest1_catlog"

No match found for search pattern: %.LIUYL_BAK

hdbsql BK1=>

\dc LIUYL_BAK.baktest1_catlog

No match found for search pattern: LIUYL_BAK.BAKTEST1_CATLOG

hdbsql BK1=>

\dc LIUYL_BAK."baktest1_catlog"

Table "LIUYL_BAK.baktest1_catlog"

| Column Name | Type | Len | Nul | Key |

| BACKUP_ID | BIGINT | 19 | NO | n/a |

| DESTINATION_PATH | VARCHAR | 512 | YES | n/a |

hdbsql BK1=> >

> > \dc "LIUYL_BAK.baktest1_catlog"

No match found for search pattern: %.LIUYL_BAK.baktest1_catlog

hdbsql BK1=> > >

\dc SYS.P_PSES_

Table "SYS.P_PSES_"

Column Name,Type,Length,Nullable,Keypos

"ID","BIGINT","19","NO","n/a"

"NAME","NVARCHAR","256","YES","n/a"

"PURPOSE","TINYINT","3","NO","n/a"

"OWNER","BIGINT","19","NO","n/a"