SHOW CREATE PUBLIC SYNONYM
功能说明
显示给定的公有同义词的创建语句。
语法格式
SHOW CREATE PUBLIC SYNONYM [vc_name.]sym_name;
表5- 131 参数说明
参数名称
说
明
vc_name
vc 名,可选项。
syn_name
同义词名。
示例
示例1:查看公有同义词s2 的创建语句:
gbase> CREATE PUBLIC SYNONYM s2 FOR demo.t1;
Query OK, 0 rows affected (Elapsed: 00:00:00.03)
gbase> SHOW CREATE PUBLIC SYNONYM s2;
+---------+----------------------------------------------+
| Synonym | Create synonym
|
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1133
+---------+----------------------------------------------+
| vc1.s2
| CREATE PUBLIC SYNONYM vc1.s2 FOR vc1.demo.t1 |
+---------+----------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> SHOW CREATE PUBLIC SYNONYM vc1.s2;
+---------+----------------------------------------------+
| Synonym | Create synonym
|
+---------+----------------------------------------------+
| vc1.s2
| CREATE PUBLIC SYNONYM vc1.s2 FOR vc1.demo.t1 |
+---------+----------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)