StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POremoving text from richtextbox
text
Body
copied!<p>I have richtextbox1 and want to remove all the <strong><em>"USER1".</em></strong> from below , if sentence starts with ALTER TABLE and consists "USER1". what is the best way to do that using C#</p> <p><em><strong>my text on richtextbox</em></strong></p> <pre><code>DROP INDEX XIE2TBL_A; DROP INDEX XPKTBL_A; ALTER TABLE "COURSE" DROP CONSTRAINT "CRSE_CRSE_FK"; ALTER TABLE "ENROLLMENT" DROP CONSTRAINT "ENR_STU_FK"; ALTER TABLE "ENROLLMENT" DROP CONSTRAINT "ENR_SECT_FK"; ALTER TABLE "ENROLLMENT" ADD CONSTRAINT "ENR_STU_FK" FOREIGN KEY ("STUDENT_ID") REFERENCES "USER1"."STUDENT"("STUDENT_ID") ENABLE; ALTER TABLE "ENROLLMENT" ADD CONSTRAINT "ENR_SECT_FK" FOREIGN KEY ("SECTION_ID") REFERENCES "USER1"."SECTION"("SECTION_ID") ENABLE; ALTER TABLE "GRADE" DROP CONSTRAINT "GR_ENR_FK"; ALTER TABLE "GRADE" DROP CONSTRAINT "GR_GRTW_FK"; ALTER TABLE "GRADE" ADD CONSTRAINT "GR_ENR_FK" FOREIGN KEY ("STUDENT_ID","SECTION_ID") REFERENCES "USER1"."ENROLLMENT"("STUDENT_ID","SECTION_ID") ENABLE; ALTER TABLE "GRADE" ADD CONSTRAINT "GR_GRTW_FK" FOREIGN KEY ("SECTION_ID","GRADE_TYPE_CODE") REFERENCES "USER1"."GRADE_TYPE_WEIGHT"("SECTION_ID","GRADE_TYPE_CODE") ENABLE; ALTER TABLE "GRADE_TYPE_WEIGHT" DROP CONSTRAINT "GRTW_GRTYP_FK"; ALTER TABLE "GRADE_TYPE_WEIGHT" DROP CONSTRAINT "GRTW_SECT_FK"; ALTER TABLE "GRADE_TYPE_WEIGHT" ADD CONSTRAINT "GRTW_GRTYP_FK" FOREIGN KEY ("GRADE_TYPE_CODE") REFERENCES "USER1"."GRADE_TYPE"("GRADE_TYPE_CODE") ENABLE; ALTER TABLE "GRADE_TYPE_WEIGHT" ADD CONSTRAINT "GRTW_SECT_FK" FOREIGN KEY ("SECTION_ID") REFERENCES "USER1"."SECTION"("SECTION_ID") ENABLE; ALTER TABLE "INSTRUCTOR" DROP CONSTRAINT "INST_ZIP_FK"; ALTER TABLE "INSTRUCTOR" ADD CONSTRAINT "INST_ZIP_FK" FOREIGN KEY ("ZIP") REFERENCES "USER1"."ZIPCODE"("ZIP") ENABLE; ALTER TABLE "SECTION" DROP CONSTRAINT "SECT_INST_FK"; </code></pre> <p><em><strong>I want this:</em></strong> </p> <pre><code> DROP INDEX XIE2TBL_A; DROP INDEX XPKTBL_A; ALTER TABLE "COURSE" DROP CONSTRAINT "CRSE_CRSE_FK"; ALTER TABLE "ENROLLMENT" DROP CONSTRAINT "ENR_STU_FK"; ALTER TABLE "ENROLLMENT" DROP CONSTRAINT "ENR_SECT_FK"; ALTER TABLE "ENROLLMENT" ADD CONSTRAINT "ENR_STU_FK" FOREIGN KEY ("STUDENT_ID") REFERENCES "STUDENT"("STUDENT_ID") ENABLE; ALTER TABLE "ENROLLMENT" ADD CONSTRAINT "ENR_SECT_FK" FOREIGN KEY ("SECTION_ID") REFERENCES "SECTION"("SECTION_ID") ENABLE; ALTER TABLE "GRADE" DROP CONSTRAINT "GR_ENR_FK"; ALTER TABLE "GRADE" DROP CONSTRAINT "GR_GRTW_FK"; ALTER TABLE "GRADE" ADD CONSTRAINT "GR_ENR_FK" FOREIGN KEY ("STUDENT_ID","SECTION_ID") REFERENCES "ENROLLMENT"("STUDENT_ID","SECTION_ID") ENABLE; ALTER TABLE "GRADE" ADD CONSTRAINT "GR_GRTW_FK" FOREIGN KEY ("SECTION_ID","GRADE_TYPE_CODE") REFERENCES "GRADE_TYPE_WEIGHT"("SECTION_ID","GRADE_TYPE_CODE") ENABLE; ALTER TABLE "GRADE_TYPE_WEIGHT" DROP CONSTRAINT "GRTW_GRTYP_FK"; ALTER TABLE "GRADE_TYPE_WEIGHT" DROP CONSTRAINT "GRTW_SECT_FK"; ALTER TABLE "GRADE_TYPE_WEIGHT" ADD CONSTRAINT "GRTW_GRTYP_FK" FOREIGN KEY ("GRADE_TYPE_CODE") REFERENCES "GRADE_TYPE"("GRADE_TYPE_CODE") ENABLE; ALTER TABLE "GRADE_TYPE_WEIGHT" ADD CONSTRAINT "GRTW_SECT_FK" FOREIGN KEY ("SECTION_ID") REFERENCES "SECTION"("SECTION_ID") ENABLE; ALTER TABLE "INSTRUCTOR" DROP CONSTRAINT "INST_ZIP_FK"; ALTER TABLE "INSTRUCTOR" ADD CONSTRAINT "INST_ZIP_FK" FOREIGN KEY ("ZIP") REFERENCES "ZIPCODE"("ZIP") ENABLE; ALTER TABLE "SECTION" DROP CONSTRAINT "SECT_INST_FK"; </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload