CNGE13的博客

常用语句 结构 表结构 -- 添加列 ALTER TABLE [dbo].[INPAT_FEE] ADD ATC NVARCHAR(20) -- 添加自增列 alter table [dbo].[第五部分] add id int identity(1,1) not null -- 删除列 ALTER TABLE [dbo].[INPAT_FEE] DROP COLUMN ATC -- 更改列属性 Alter table [表名] alter column [列名] 类型 -- 修改列名 EXEC sp_

– 连接 sqlplus sys/sys as sysdba; – 创建用户 create user ZLHIS identified by ZLHIS_2020; – 删除用户 drop user yb CASCADE; – 权限 grant connect,resource,dba to ZLHIS; grant dba to ZLHIS; –表空间 create tablespace ZL9MTLBASE datafile ‘E:\TABLESPACE\ZL9MTLBASE.dbf’ size 200

权限相关 -- 创建用户 CREATE USER 'gcn'@'localhost' IDENTIFIED BY '123456'; -- 创建一个用户 一个库的所有权限 grant all on ry.* to test_user@'%' identified by '123456'; --授予权限给用户 grant select, insert, update, delete on java_se.* to test_user@'%'; grant select, insert, update,