Kingbase中的基础sql语句

1.创建
TABLESPACE：CREATE TABLESPACE fcj OWNER fcj LOCATION '/home/kingbase/tbs/fcj/';
USER：CREATE USER fcj SUPERUSER CREATEDB CREATEROLE LOGIN REPLICATION ENCRYPTED PASSWORD '123456';
DB：CREATE DATABASE fcj WITH OWNER = "SYSTEM" ENCODING UTF8 TABLESPACE fcj TEMPLATE template0;
SCHEMA：CREATE SCHEMA fcj AUTHORIZATION fcj;
2.赋权与回收权限
grant USAGE,CREATE ON SCHEMA fcj to fcj;/grant ALL ON SCHEMA fcj to fcj;
REVOKE USAGE,CREATE ON SCHEMA fcj FROM fcj;/REVOKE ALL ON SCHEMA fcj FROM fcj;
3.查看所有数据库大小
select datname, sys_size_pretty(sys_database_size(datname)) AS size from sys_database;
4.查看某个数据库大小
select sys_size_pretty(sys_database_size('fcj')) AS size;或者\l+
5.查看某张表大小
select sys_size_pretty(sys_relation_size('fcj1')) AS size;或者\dt+
6.查询所有表大小
select relname, sys_size_pretty(sys_relation_size(relid)) AS size from sys_stat_user_tables;
7.查询单个表总大小，包括该表的索引大小
select sys_size_pretty(sys_total_relation_size('fcj1')) AS size;
8.查询所有表总大小，包括其索引大小
select relname, sys_size_pretty(sys_total_relation_size(relid)) AS size from sys_stat_user_tables;
9.查询单个索引大小（暂时没有一次性查询所有索引大小的函数）
select sys_size_pretty(sys_relation_size('index_name')) AS size;
10.查询单个表空间大小
select sys_size_pretty(sys_tablespace_size('sys_default')) AS size;
11.查询所有表空间大小
select spcname, sys_size_pretty(sys_tablespace_size(spcname)) AS size from sys_tablespace;
或者
select spcname, sys_size_pretty(sys_tablespace_size(oid)) AS size from sys_tablespace;