DESCRIBE NOTEBOOK¶
描述 笔记本 的属性。
DESCRIBE 可以缩写为 DESC。
语法¶
{ DESC | DESCRIBE } NOTEBOOK <name>
参数¶
name指定要描述的笔记本的标识符。
如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。
有关更多信息，请参阅 标识符要求。
输出¶
命令的输出包括以下列，它们描述了对象的属性和元数据：
列 |
描述 |
|---|---|
|
创建笔记本时的日期和时间。 |
访问控制要求¶
权限 |
对象 |
备注 |
|---|---|---|
USAGE 或 OWNERSHIP |
笔记本 |
OWNERSHIP 是对对象的特殊权限，会自动向对象的创建角色授予。笔记本的所有权无法转让。 |
使用说明¶
To post-process the output of this command, you can use the pipe operator (
->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.For example, you can use the pipe operator or RESULT_SCAN function to select specific columns from the SHOW command output or filter the rows.
When you refer to the output columns, use double-quoted identifiers for the column names. For example, to select the output column
type, specifySELECT "type".You must use double-quoted identifiers because the output column names for SHOW commands are in lowercase. The double quotes ensure that the column names in the SELECT list or WHERE clause match the column names in the SHOW command output that was scanned.
示例¶
以下示例描述名为 mybook 的笔记本：
DESCRIBE NOTEBOOK mybook;