Kingbase怎么查看表ddl的时间
时间: 2024-02-23 14:57:47 浏览: 195
你可以通过以下的SQL语句查看Kingbase数据库中表的DDL时间:
```
SELECT relname, nspname, relhasindex, relkind, relchecks, reltriggers, relhasrules, relfrozenxid, relacl, relowner, relnamespace, reltype, relstorage, relam, relpages, reltuples, reltoastrelid, reltoastidxid, relhasoids, relhassubclass, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relpartbound, relpartbound_inclusive, relispartition, relisshared, relpersistence, relkind, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relpartbound, relpartbound_inclusive, relispartition, relisshared, relpersistence, reltablespace, reltoasttablespace, relfilenode, reltablespace, reltoasttablespace, relfilenode, relminmxid, relfrozenxid, relallvisible, relpages, reltuples, relallvisible, relfrozenxid, relminmxid, relhasindex, relhasrules, relhastriggers, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relpartbound, relpartbound_inclusive, relispartition, relisshared, relpersistence, reltablespace, reltoasttablespace, relfilenode, relpages, reltuples, relallvisible, relfrozenxid, relminmxid, relacl, relowner, relnamespace, reltype, relstorage, relam, reltoastidxid, reltoastrelid, relhasoids, relhassubclass, relchecks, reltriggers, relhasindex, relkind, relchecks, reltriggers, relhasrules, relfrozenxid, relacl, relowner, relnamespace, reltype, relstorage, relam, relpages, reltuples, reltoastrelid, reltoastidxid, relhasoids, relhassubclass, relrowsecurity, relforcerowsecurity, relispopulated, relreplident, relpartbound, relpartbound_inclusive, relispartition, relisshared, relpersistence, reltablespace, reltoasttablespace, relfilenode, relallvisible, relfrozenxid, relminmxid, relhasindex, relhasrules, relhastriggers FROM pg_class c, pg_namespace n WHERE c.relnamespace = n.oid AND n.nspname = 'public' AND c.relname = 'table_name';
```
请将上面的SQL语句中的“table_name”替换为你要查询的表名,即可查看该表的DDL时间。
阅读全文