FirebirdSQL/問答篇/SQLCommand取得資料表格
出自VFP Wiki
(修訂版本間差異)
小 (revert) |
1148973871 (對話 | 貢獻) |
||
第11行: | 第11行: | ||
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE SUBSTR(RDB$RELATION_NAME,1,3)<>'RDB' AND SUBSTR(RDB$RELATION_NAME,1,3)<>'IBE' ORDER BY RDB$RELATION_NAME | SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE SUBSTR(RDB$RELATION_NAME,1,3)<>'RDB' AND SUBSTR(RDB$RELATION_NAME,1,3)<>'IBE' ORDER BY RDB$RELATION_NAME | ||
</pre> | </pre> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <div style="display:none"> | ||
+ | [We are delicate. We do not delete your content.] | ||
+ | [l_sp21] | ||
+ | |||
+ | |||
+ | [http://www.buddyprofile.com/viewprofile.php?username=waterfordcrystal waterford crystal] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=swarovskicrystal swarovski crystal bead] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomalawsuits mesothelioma lawsuits] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomasymptoms mesothelioma symptoms] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomadiag mesothelioma diagnosis] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=wacoalbras wacoal bras] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=teenbra teen bra] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=unsecuredloan unsecured signature loan] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=homeloans Countrywide Home Loans] | ||
+ | [http://blog.moddingplanet.it/?w=formalpromdresses Formal Prom Dresses] | ||
+ | [http://blog.moddingplanet.it/?w=sexypromdress Sexy Prom Dress] | ||
+ | [http://blog.moddingplanet.it/?w=cocktaildresses cocktail dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=telmobile TMobile] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=watersoftener water softener] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=tanklesswaterheater tankless water heater] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=rockportshoes rockport shoes] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=osmosiswaterfilter reverse osmosis water filter] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=merrellshoes merrell shoes] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=oscardresses oscar dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=easterdresses easter dresses] | ||
+ | [http://flyfone.blox.pl/resource/flyfonevoip.htm flyfone voip] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=plussizepromdresses plus size prom dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=discountpromdresses discount prom dresses] | ||
+ | [http://blog.moddingplanet.it/?w=hooterscasinolas Hooters Casino Las Vegas] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinomille grand casino mille lacs] | ||
+ | [http://blog.moddingplanet.it/?w=lasvegascasino las vegas casino coupons] | ||
+ | [http://blog.moddingplanet.it/?w=onlinepokeraide online poker aide] | ||
+ | [http://www.donx.de/blog/pechangacasino pechanga casino] | ||
+ | [http://www.donx.de/blog/grandvictoriacasino/ grand victoria casino] | ||
+ | [http://www.donx.de/blog/ballgowns/ ball gowns] | ||
+ | [http://www.privetparis.com/blog/rtgcasinobonus/ rtg casino bonus] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=rtgcasinobonus rtg casino bonus] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinocoushat grand casino coushatta] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinohinckle grand casino hinckley] | ||
+ | [http://blog.moddingplanet.it/?w=isleofcapricasino isle of capri casino] | ||
+ | [http://blog.moddingplanet.it/?w=mohegansuncasino mohegan sun casino] | ||
+ | [http://blog.moddingplanet.it/?w=palacasino pala casino] | ||
+ | [http://blog.moddingplanet.it/?w=roulettewheels roulette wheels] | ||
+ | [http://blog.moddingplanet.it/?w=winstarcasino winstar casino] | ||
+ | [http://blog.moddingplanet.it/?w=cheappromdresses Cheap Prom Dresses] | ||
+ | [http://blog.moddingplanet.it/?w=informalweddingdre informal wedding dresses] | ||
+ | [http://blog.moddingplanet.it/?w=oscardresses oscar dresses] | ||
+ | [http://blog.moddingplanet.it/?w=eveninggowns evening gowns] | ||
+ | |||
+ | [http://vvvvvv.blox.pl/resource/throat_pokers.htm throat pokers] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_assistant.htm online poker assistant] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_tracker.htm online poker tracker] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_aide.htm online poker aide] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus.htm party poker bonus] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus_code.htm party poker bonus code] | ||
+ | [http://vvvvvv.blox.pl/resource/bonus_code_party_poker.htm bonus code party poker] | ||
+ | [http://vvvvvv.blox.pl/resource/bonus_code_deposit_party_poker.htm bonus code deposit party poker] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus_codes.htm party poker bonus codes] | ||
+ | [http://vvvvvv.blox.pl/resource/carnival_cruises.htm carnival cruises] | ||
+ | [http://vvvvvv.blox.pl/resource/carnival_game_rentals.htm carnival game rentals] | ||
+ | [http://vvvvvv.blox.pl/resource/fuzzydice.htm fuzzy dice] | ||
+ | [http://vvvvvv.blox.pl/resource/bingodaubers.htm bingo daubers] | ||
+ | [http://vvvvvv.blox.pl/resource/bingoblowers.htm bingo blowers] | ||
+ | [http://vvvvvv.blox.pl/resource/motor_scooters.htm motor scooters] | ||
+ | [http://vvvvvv.blox.pl/resource/mini_harley_chopper_scooter.htm mini harley chopper scooter] | ||
+ | [http://blog.moddingplanet.it/?w=fakerolex fake rolex] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=bextravioxx bextra vioxx] | ||
+ | [http://blog.moddingplanet.it/?w=zocor zocor] | ||
+ | [http://blog.moddingplanet.it/?w=zithromax zithromax] | ||
+ | [http://blog.moddingplanet.it/?w=bextralawyernew bextra lawyer new hampshire] | ||
+ | [http://blog.moddingplanet.it/?w=akanesoma akane soma] | ||
+ | [http://blog.moddingplanet.it/?w=kyosoma kyo soma] | ||
+ | [http://blog.moddingplanet.it/?w=prozacnation prozac nation] | ||
+ | [http://blog.moddingplanet.it/?w=prozacwithdrawal prozac withdrawal] | ||
+ | [http://blog.moddingplanet.it/?w=simslots sim slots] | ||
+ | [http://blog.moddingplanet.it/?w=pachisloslotmachine pachislo slot machines] | ||
+ | [http://blog.moddingplanet.it/?w=programcherries program cherries wild slot machine] | ||
+ | [http://blog.moddingplanet.it/?w=slotcarracing slot car racing] | ||
+ | [http://blog.moddingplanet.it/?w=hoslotcars ho slot cars] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=bingocages bingo cages] | ||
+ | [http://blog.moddingplanet.it/?w=bingodaubers bingo daubers] | ||
+ | [http://blog.moddingplanet.it/?w=bingoblowers bingo blowers] | ||
+ | [http://blog.moddingplanet.it/?w=bingobags bingo bags] | ||
+ | [http://blog.moddingplanet.it/?w=baccaratcrystal baccarat crystal] | ||
+ | [http://blog.moddingplanet.it/?w=nexium nexium] | ||
+ | [http://blog.moddingplanet.it/?w=onlinepaigowpoker online pai gow poker] | ||
+ | [http://blog.moddingplanet.it/?w=leighkeno leigh keno] | ||
+ | |||
+ | [http://www.privetparis.com/blog/tramadol50mg/ tramadol 50mg] | ||
+ | [http://www.privetparis.com/blog/tramadolsaturdaydelivery/ tramadol saturday delivery] | ||
+ | [http://www.privetparis.com/blog/tramadoler/ tramadol er] | ||
+ | [http://www.privetparis.com/blog/tramadolsales/ tramadol sales] | ||
+ | [http://www.privetparis.com/blog/tramadolhcl50mg/ tramadol hcl 50 mg] | ||
+ | [http://www.privetparis.com/blog/120tramadoll/ 120 tramadol] | ||
+ | [http://www.privetparis.com/blog/acetaminophenhclpartramadol/ acetaminophen hcl par tramadol] | ||
+ | [http://blog.moddingplanet.it/?w=plussizemother plus size mother of the bride dresses] | ||
+ | [http://blog.moddingplanet.it/?w=cheapflowergirl cheap flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=discountflowergirl discount flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=infantflowergirl infant flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=bridalflowergirl bridal flower girl dresses] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=discountbridesmaid discount bridesmaid dresses] | ||
+ | [http://blog.moddingplanet.it/?w=juniorbridesmaid junior bridesmaid dresses] | ||
+ | [http://blog.moddingplanet.it/?w=cheapbridesmaid cheap bridesmaid dresses] | ||
+ | [http://blog.moddingplanet.it/?w=plussizebridesmaid plus size bridesmaid dresses] | ||
+ | [http://blog.moddingplanet.it/?w=weddingbridesmaid wedding bridesmaid dresses] | ||
+ | [http://blog.moddingplanet.it/?w=maternitybridesmaid maternity bridesmaid dresses] | ||
+ | </div> |
在2006年5月30日 (二) 06:42所做的修訂版本
By Ruey
Select RDB$RELATION_NAME from RDB$RELATIONS where RDB$VIEW_BLR is NULL ORDER BY RDB$RELATION_NAME 不包含系統表的清單 Select RDB$RELATION_NAME from RDB$RELATIONS where RDB$VIEW_BLR is NULL and RDB$SYSTEM_FLAG = 0 ORDER BY RDB$RELATION_NAME 或者 SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE SUBSTR(RDB$RELATION_NAME,1,3)<>'RDB' AND SUBSTR(RDB$RELATION_NAME,1,3)<>'IBE' ORDER BY RDB$RELATION_NAME