Urgent Help required : awk/sed help to find pattern and delete till end of line

Hi,

I need help with using an awk or sed filter on the below line

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "ACCOUNT_PK" PRIMARY KEY ("ACCT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "WMC_DATA" LOGGING ENABLE

Look for Pattern "USING" from above and remove from matched pattern till the end of line.

Desired Output

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "ACCOUNT_PK" PRIMARY KEY ("ACCT_ID")

Quick responses appreciated

Thanks,
Rajan

sed 's/USING.*$//' 

is the basic sed command to use. I cannot tell if you want to echo the line as a varaible thru sed or run sed against a file.