congzhou2603 commented on issue #25104: URL: https://github.com/apache/shardingsphere/issues/25104#issuecomment-1511011944
Here is an exmaple for creating and dropping foreigin table. “SERVER 'mot_server’” corresponeds to "SERVER gsmpp_server" in syntax, among which "gsmpp_server" indicates the server name of foreign table. "FOREIGN " and "SERVER gsmpp_server" both can be transparently transmitted to openGauss. ``` sql CREATE FOREIGN TABLE t_order ( user_id int, order_name varchar(30), order_value varchar(50), order_id int default 0 ) SERVER mot_server; DROP FOREIGN TABLE t_order; ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
