# 查看DEPLOYMENT详情(SHOW DEPLOYMENT)

```
SHOW DEPLOYMENT deployment_name;
```

`SHOW DEPLOYMENT`语句用于显示某一个OnlineServing的详情。

### Example

创建一个数据库，并设置为当前数据库:

```sql
CREATE DATABASE db1;
-- SUCCEED: Create database successfully

USE db1;
-- SUCCEED: Database changed

```

创建一张表`t1`:

```sql
CREATE TABLE t1(col0 STRING);
-- SUCCEED: Create successfully
```

部署表t1的查询语句到OnlineServing:

```sql
DEPLOY demo_deploy select col0 from t1;
-- SUCCEED: deploy successfully
```

查看新部署的deployment:

```sql
SHOW DEPLOYMENT demo_deploy;
```

```
 ----- ------------- 
  DB    Deployment   
 ----- ------------- 
  db1   demo_deploy  
 ----- ------------- 
 1 row in set
 
 ---------------------------------------------------------------------------------- 
  SQL                                                                               
 ---------------------------------------------------------------------------------- 
  CREATE PROCEDURE deme_deploy (col0 varchar) BEGIN SELECT
  col0
FROM
  t1
; END;  
 ---------------------------------------------------------------------------------- 
1 row in set

# Input Schema
 --- ------- ---------- ------------ 
  #   Field   Type       IsConstant  
 --- ------- ---------- ------------ 
  1   col0    kVarchar   NO          
 --- ------- ---------- ------------ 

# Output Schema
 --- ------- ---------- ------------ 
  #   Field   Type       IsConstant  
 --- ------- ---------- ------------ 
  1   col0    kVarchar   NO          
 --- ------- ---------- ------------ 
```

## 相关语句

[USE DATABASE](https://tobe.gitbook.io/hybridsql/hybridse/shi-yong-wen-dang/reference/reference-5/use_database_statement)

[DEPLOY](https://tobe.gitbook.io/hybridsql/hybridse/shi-yong-wen-dang/reference/reference-6/deploy_statement)

[DROP DEPLOYMENT](https://tobe.gitbook.io/hybridsql/hybridse/shi-yong-wen-dang/reference/reference-6/drop_deployment_statement)
