常用sql

1、oracle增加表SYSENUM，设置主键ENUMNAME, ENUMVALUE：

create table SYSENUM
(
  ENUMNAME    VARCHAR2(50)  not null,
  ENUMVALUE       VARCHAR2(50)  not null
)
tablespace PPMS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );

alter table SYSENUM
  add constraint PK_SYSENUM primary key (ENUMNAME, ENUMVALUE)
  using index
  tablespace PPMS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

2、sqlserver2005增加表SYSENUM，设置主键ENUMNAME, ENUMVALUE：

 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sysenum]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[sysenum](
 [enumname] [varchar](50) NOT NULL,
 [enumvalue] [varchar](50) NOT NULL,
 CONSTRAINT [PK_sysenum] PRIMARY KEY CLUSTERED
(
 [enumname] ASC,
 [enumvalue] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO

3、oracle修改表users字段rolename

 alter  table users modify  rolename varchar(200);

4、sqlserver2005修改表users字段rolename

 ALTER TABLE users ALTER COLUMN rolename varchar(200);