saphana 常用sql语法整理(类似oracle需要创建schema)

常用语法-

在这里插入代码查询
select  * from EBA.TEST_TABLE;
更新
update EBA.TEST_TABLE set NAME = '小志呀' where NAME = '小明';
添加
insert into EBA.TEST_TABLE values (4,'笔记本',100);
删除
delete from EBA.TEST_TABLE where ID = 2;

创建schema
create schema eba;

创建指定用户的schema
CREATE SCHEMA my_schema OWNED BY system;

查询某一用户的所有schema
select t.* from SCHEMAS t WHERE SCHEMA_OWNER = 'SYSTEM'

查询当前schema下的所有表
select table_name from tables where schema_name = 'EBA';

select table_name from tables where schema_name ='SYSTEM';

create table EBA.eba_test1
(
    id   int,
    name varchar(50),
    age  int
);

create table EBA.eba_test22
(
    eba_id   varchar(36),
    type varchar(50),
    create_data  DATE,
    money numeric
);

create table EBA.ads_test
(
    id   varchar(36),
    type varchar(50)
);