Transact-SQL 语法约定 语法 syntaxsql 复制 OBJECT_SCHEMA_NAME ( object_id [, database_id ] ) 参数 object_id 要使用的对象的 ID。 object_id 的数据类型为 int,并假定为指定数据库或当前数据库上下文中的架构范围内的对象。 database_id 要在其中查找对象的数据库的 ID。database_id 为 int。 返...
=0\G;***1.row***OBJECT_TYPE:TABLEOBJECT_SCHEMA:xiaoboluoOBJECT_NAME:test...COUNT_READ_NORMAL:0SUM_TIMER_READ_NORMAL:0MIN_TIMER_READ_NORMAL:0AVG_TIMER_READ_NORMAL:0MAX_TIMER_READ_NORMAL:0COUNT_READ_WITH_SHARED_LOCKS:0SUM_TIMER_READ_WITH_SHARED_LOCKS:0MIN_TIMER_READ_WITH_SHARED_LOCKS:...
适用于: SQL Server Azure SQL 数据库 Azure SQL 托管实例 每当MICROSOFT SQL Server 中的任何用户为架构对象权限颁发 GRANT、REVOKE 或 DENY 时,都会出现 Audit Schema Object GDR 事件类。 Audit Schema Object GDR Event 事件类的数据列 展开表 数据列名称数据类型说明列ID可筛选 ApplicationName nvarchar...
OBJECT_SCHEMA_NAME (Transact-SQL)返回架构范围内对象的数据库架构名称。有关架构范围内对象的列表,请参阅 sys.objects (Transact-SQL)。 Transact-SQL 语法约定 语法 复制 OBJECT_SCHEMA_NAME ( object_id [, database_id ] ) 参数 object_id 要使用的对象的 ID。object_id 的数据类型为 int,并假定为...
Example 17.2 InnoDB INFORMATION_SCHEMA Schema Object Tables This example uses a simple table (t1) with a single index (i1) to demonstrate the type of metadata found in theInnoDBINFORMATION_SCHEMAschema object tables. Create a test database and tablet1: ...
The data of each object is physically contained in one or more of the tablespace's datafiles. For some objects such as tables, indexes, and clusters, you can specify how much disk space Oracle allocates for the object within the tablespace's datafiles. ...
mysql> SELECT OBJECT_NAME,INDEX_NAME,COUNT_FETCH,COUNT_INSERT,COUNT_UPDATE,COUNT_DELETE FROM table_io_waits_summary_by_index_usage ORDER BY SUM_TIMER_WAIT DESC; +---+---+---+---+---+---+ | OBJECT_NAME | INDEX_NAME | COUNT_FETCH | COUNT_INSERT | COUNT_UPDATE | COUNT_DELETE |...
events_waits_summary_by_instance表:按照列EVENT_NAME、OBJECT_INSTANCE_BEGIN进行分组事件信息。如果一个instruments(event_name)创建有多个实例,则每个实例都具有唯一的OBJECT_INSTANCE_BEGIN值,因此每个实例会进行单独分组 events_waits_summary_by_thread_by_event_name表:按照列THREAD_ID、EVENT_NAME进行分组事件信息...
Applies to: SQL Server Azure SQL Managed InstanceThis topic describes how to specify schema options in SQL Server by using SQL Server Management Studio or Transact-SQL. When you are publishing a table or view, you can control the object creation options that are replicated for the published ...
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as identifiers. This section describes the permissible syntax for identifiers in MySQL. Section 9.2.1, “Identifier Length Limits”, ...