GO
਍ഀഀ
CREATE TABLE [dbo].[tblCaseTypes] (
਍ऀ嬀䌀愀猀攀吀礀瀀攀倀䬀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰഀഀ
     [CaseTypeName] [nvarchar] (32) ,

    START WITH 1 MAXVALUE 2.0E9 MINVALUE 1 NOCYCLE
    CACHE 200 ORDER;
CREATE TABLE jforum_banlist (
    banlist_id NUMBER(10),
    user_id NUMBER(10) DEFAULT 0,

alter table person drop alias;

ALTER TABLE comments ADD COLUMN deleted integer;
ALTER TABLE comments ALTER COLUMN deleted SET DEFAULT 0;

ALTER TABLE task add description varchar(2000);

ALTER TABLE `appointment` ADD INDEX ( `event_id` );
ALTER TABLE `event` ADD INDEX ( `start` );
ALTER TABLE `event` ADD INDEX ( `end` );

create table tmp (data numeric default 5);
alter table tmp alter column data drop default;
alter table tmp alter column data set default 6;

create table atacc1 (test int not null);
alter table atacc1 alter bar set not null;
alter table atacc1 alter test set not null;

ALTER TABLE "text" RENAME TO pagecontent;

ALTER TABLE "user" RENAME TO mwuser;

ALTER TABLE Patients
ADD Telephone nvarchar(25)

ALTER TABLE `userliste` ADD `msns` TEXT;

ALTER TABLE `incident` DROP `id_hardware` ;

ALTER TABLE `incident` DROP `id_hardware` ;

ALTER TABLE DOMAIN EMP RENAME TO EMPLOYEE;

ALTER TABLE ID IIT RENAME TO EMP;

ALTER TABLE EMP RENAME TO EMPLOYEE;

ALTER TABLE DOMAIN PRICE RENAME TO COST;

ALTER TABLE ID IIT RENAME TO EMP;

ALTER TABLE DOMAIN EMP RENAME TO EMPLOYEE;

ALTER TABLE EMP RENAME TO EMPLOYEE;

ALTER TABLE DOMAIN PRICE RENAME TO COST;

ALTER TABLE `item` DROP PRIMARY KEY;

alter table layout add defaultsegment varchar2(128);

ALTER TABLE activities ADD autostatuson DECIMAL(1);