SQL Server synonym yog dab tsi?
SQL Server synonym yog dab tsi?

Video: SQL Server synonym yog dab tsi?

Video: SQL Server synonym yog dab tsi?
Video: What is Database & SQL? 2024, Kaum ib hlis
Anonim

Hauv SQL Server , a lub ntsiab lus yog lub npe hu ua alias lossis lwm lub npe rau cov khoom siv database xws li lub rooj, saib, cov txheej txheem khaws cia, tus neeg siv kev ua haujlwm, thiab ntu ntu. A lub ntsiab lus muab ntau yam txiaj ntsig rau koj yog tias koj siv nws kom raug.

Tsis tas li lo lus nug yog, kev siv cov lus sib dhos hauv SQL yog dab tsi?

A lub ntsiab lus yog lwm lub npe rau cov khoom xws li rooj, views, sequences, khaws cia cov txheej txheem, thiab lwm yam khoom siv database. Koj feem ntau siv synonyms thaum koj tso cai nkag mus rau ib qho khoom los ntawm lwm lub schema thiab koj tsis xav kom cov neeg siv yuav tsum txhawj xeeb txog kev paub txog qhov twg schema yog tus tswv ntawm cov khoom.

Tom qab ntawd, lo lus nug yog, dab tsi yog hom lus ntawm SQL? Muaj ob hom synonyms:

  • tus kheej. Private synonyms tsuas muaj nyob rau hauv ib tug neeg siv schema. Tus tswv ntawm lub ntsiab lus tswj hwm kev muaj rau lwm tus neeg siv.
  • pej xeem. Ib tug pej xeem synonym yog muaj rau tag nrho cov neeg siv nyob rau hauv lub database.

Tom qab, lo lus nug yog, dab tsi yog synonyms hauv database?

A lub ntsiab lus yog ib qho alias lossis lwm lub npe rau ib lub rooj, saib, ntu, lossis lwm yam khoom siv schema. Lawv feem ntau yog siv los ua kom yooj yim rau cov neeg siv nkag database cov khoom muaj los ntawm lwm tus neeg siv. Lawv zais cov khoom hauv qab tus kheej thiab ua rau nws nyuaj rau qhov kev pab cuam siab phem lossis tus neeg siv los tsom rau cov khoom hauv qab.

Peb puas tuaj yeem ntxig cov ntaub ntawv rau hauv cov lus sib dhos hauv SQL Server?

A Synonym tau kuj tseem siv tau los hais txog cov haujlwm uas tus neeg siv tau hais tseg. SQL Server tso cai rau koj los ua ntau hom kev ua haujlwm ntawm lub Synonyms , uas hloov lub cov ntaub ntawv thiab tsis yog schema ntawm cov khoom, xws li SELECT, INSERT , Hloov kho, DELETE lossis EXECUTE cov haujlwm.

Pom zoo: