When we execute DESCRIBE TABLE command in our database we will be able to view the structure of the table in a describe tab but not on the console tab of the system software. The SQL DESCRIBE TABLE query will m
The value being transformed is one of the following: * an argument to a user defined function (UDF) * an input to the SET clause of an UPDATE statement * a value being INSERTed into a table * an input to a cast or adjustment function in some other context * a recursively referenced c...
但此查询中表变量的declare会导致激活CREATE_TABLE之后的事件的数据库触发器，其中包含对带有temp表的存储...
sp_tableoption 'text in row' 不可为 Null。 precision tinyint 如果为基于数值的列,则为该列的精度。 否则返回 0。 不可为 Null。 scale tinyint 如果基于数值,则为列的小数位数。 否则返回 0。 不可为 Null。 collation_name sysname 如果列包含的是字符,则为该列的排序规则的名称。 否...
10 TEMPORARY_TABLE 無法判斷結果,因為批次包含暫存表,sp_describe_first_result_set 不支援 。 11 UNSUPPORTED_STATEMENT 無法判斷結果,因為批次包含sp_describe_first_result_set不支援的語句(例如 FETCH、REVERT 等)。 12 OBJECT_TYPE_NOT_SUPPORTED 不支援傳遞至函式@object_id ...
Data partition expression in SQL SHOW DETAIL For the DESCRIBE TABLE command, specifies that output include the following additional information: Whether a CHARACTER, VARCHAR or LONG VARCHAR column was defined as FOR BIT DATA Column number Distribution key sequence Code page Hidden attribute Default ...
table_name StartTime string 是 查询开始时间,可查询当前日期 7 天内的数据。格式:yyyy-MM-ddTHH:mm:ssZ(UTC 时间)。 说明 当开通了 DAS 企业版 V3,使用其提供的 SQL 洞察和审计功能时,可查询数据热存储时长内的数据。通过 DescribeSqlLogConfig 可以查询开通的企业版信息。 2011-06-01T15:00:00Z Databas...
ItemsArray of StringInformation of a table. RequestIdStringThe unique request ID, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem....
SELECT * FROM table_name; ReportTime string 运行报告生成时间。格式:yyyy-MM-ddTHH:mm:ssZ(UTC 时间) 2019-03-27T16:00:00Z PageNumber integer 页码。 1 PageRecordCount integer 本页SQL 日志运行报告个数。 30 RequestId string 请求ID。 08A3B71B-FE08-4B03-974F-CC7EA6DB1828 TotalRecordCount ...
You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples. Authorization information The following table shows the authorization information corresponding to the API. The...