Cov txheej txheem:

Kuv yuav sau tag nrho cov ntxhuav hauv SQL database li cas?
Kuv yuav sau tag nrho cov ntxhuav hauv SQL database li cas?

Video: Kuv yuav sau tag nrho cov ntxhuav hauv SQL database li cas?

Video: Kuv yuav sau tag nrho cov ntxhuav hauv SQL database li cas?
Video: KOJ NYOB PUAS KAJ SIAB TUB TSWB Wwj( nkauj tawm tshiab )2023 2024, Kaum ib hlis
Anonim
  1. MySQL zoo ntawm syntax.
  2. SELECT table_name NTAWM information_schema. rooj WHERE table_type = 'base rooj ' THIAB table_schema = 'test';
  3. SQL Server .
  4. SIV xeem; // xaiv DATABASE . SELECT table_name NTAWM information_schema. rooj WHERE table_type = 'base rooj '
  5. Oracle.
  6. DB 2.
  7. PostgreSQL.

Tib neeg kuj nug, Kuv tuaj yeem pom cov ntxhuav hauv SQL database li cas?

Txhawm rau sau / qhia cov ntxhuav hauv MySQL database:

  1. Nkag mus rau hauv koj lub database siv mysql hais kom ua kab tus neeg siv khoom.
  2. Tshaj tawm cov lus txib siv los txuas rau koj cov ntaub ntawv xav tau (xws li, siv mydatabase)
  3. Siv MySQL qhia cov lus hais kom ua, zoo li no:

Kuj Paub, Kuv tuaj yeem pom tag nrho cov databases hauv SQL Server li cas? Mus saib ib daim ntawv teev cov databases ntawm ib qho piv txwv ntawm SQL Server

  1. Hauv Object Explorer, txuas mus rau ib qho piv txwv ntawm SQL Server Database Cav, thiab tom qab ntawd nthuav qhov piv txwv ntawd.
  2. Txhawm rau pom cov npe ntawm tag nrho cov databases ntawm qhov piv txwv, nthuav Databases.

Yog li ntawd, yuav ua li cas kuv sau tag nrho cov rooj nyob rau hauv ib tug database?

SQL hais kom sau tag nrho cov ntxhuav hauv Oracle

  1. Qhia tag nrho cov ntxhuav uas yog tus neeg siv tam sim no: SELECT. table_npe. Los ntawm. user_tables;
  2. Qhia tag nrho cov ntxhuav hauv cov ntaub ntawv tam sim no: SELECT. table_npe. Los ntawm. dba_tabs;
  3. Qhia tag nrho cov rooj uas siv tau los ntawm tus neeg siv tam sim no:

Qhov kev pom twg tuaj yeem siv tau kom tau txais cov npe ntawm cov ntxhuav hauv cov ntaub ntawv tshwj xeeb?

SQL Server 2005 & 2008 tau muab rau peb qhov system saib INFORMATION_SCHEMA. TABSIS Cov no tso cai rau peb yooj yim saib ntau yam ntaub ntawv rau qhov no tshwj xeeb database thiab rov qab ib kab rau txhua tus rooj (rau cov neeg siv tam sim no muaj kev tso cai).

Pom zoo: