So-net無料ブログ作成

SQL server のシステム情報(データベース一覧など)の確認

SQLServerのデータベース情報は、システムデータベースに格納されている
これをカタログ ビュー(Transact-SQL)を介して参照する

データベース sys.datebase
テーブル sys.tables
テーブル列 sys.columns
ビュー sys.views
プロシージャ sys.procedures
 
    SELECT name, database_id, create_date
    FROM sys.databases ;
    GO
 

(SQL server 2008 R2)
 


タグ:Windows SQL
nice!(0)  コメント(73)  トラックバック(0) 

nice! 0

コメント 73

CrbnOptispGF

instant loan - http://personalnerloan.org/ get out of debt <a href=http://personalnerloan.org/>small personal loans</a> ’
by CrbnOptispGF (2017-09-21 14:56) 

お名前(必須)

pro cialis
<a href="http://cialisofkl.com/">cheap cialis</a>
female cialis does it work
<a href=http://cialisofkl.com/>cialis generic</a> ’
by お名前(必須) (2017-09-23 11:00) 

お名前(必須)

cialis overnight delivery
<a href="http://cialisovnas.com/">cialis online</a>
daily cialis 5mg generic
<a href=http://cialisovnas.com/>buy cialis</a> ’
by お名前(必須) (2017-09-23 20:32) 

FfvgprailiIM

best price cialis
<a href="http://veucialis.com/">buy cialis</a>
cialis maximum effect
<a href=http://veucialis.com/>cialis online</a> ’
by FfvgprailiIM (2017-09-24 19:10) 

VqvqloakyEA

20 mg cialis
<a href="http://gawcialis.com/">cialis online</a>
side effects cialis
<a href=http://gawcialis.com/>cialis online</a> ’
by VqvqloakyEA (2017-09-24 19:11) 

お名前(必須)

cialis pharmacy
<a href="http://cialiseimah.com/">cheap cialis</a>
brand cialis over the net
<a href=http://cialiseimah.com/>cialis online</a> ’
by お名前(必須) (2017-09-25 22:26) 

お名前(必須)

female cialis review
<a href="http://cialisoakdm.com/">buy cialis</a>
cheap cialis professional
<a href=http://cialisoakdm.com/>generic cialis</a> ’
by お名前(必須) (2017-09-25 22:52) 

お名前(必須)

brand cialis buy online
<a href="http://cialisjrncd.com/">cialis online</a>
cialis from india
<a href=http://cialisjrncd.com/>generic cialis</a> ’
by お名前(必須) (2017-09-25 23:04) 

VtnoVotaSY

buy cialis 20mg price - https://jrucialis.com
cialis vs tadalafil <a href=https://jrucialis.com>buy cialis</a> ’
by VtnoVotaSY (2017-09-27 00:06) 

KrtpcoaklyDE

cialis daily 5mg - http://haycialis.com/
cialis canada free sample <a href=http://haycialis.com/>buy cialis</a> ’
by KrtpcoaklyDE (2017-09-27 00:06) 

お名前(必須)

cialis 20 mg side effects - http://cialiskanr.com
female cialis does it work <a href=http://cialiskanr.com>cialis</a>
by お名前(必須) (2017-09-27 10:34) 

お名前(必須)

price of cialis in canada - https://cialisonlin.com
cialis generic price <a href=https://cialisonlin.com>cialis</a>
by お名前(必須) (2017-09-27 11:11) 

お名前(必須)

guaranteed bad credit loans
<a href="https://cashrvyn.com/">cash advance america</a>
debt management programs
<a href="https://cashrvyn.com/">payday loan</a> ’
by お名前(必須) (2017-09-29 00:29) 

お名前(必須)

bad credit loans
<a href="https://paydayrvjlo.com/">same day payday loans</a>
personal loans no faxing
<a href=https://paydayrvjlo.com/>payday loan</a> ’
by お名前(必須) (2017-09-29 00:29) 

お名前(必須)

1 hour payday loans no credit check
<a href="https://paydayvynk.org/">pay day loan</a>
direct loan lenders online
<a href=https://paydayvynk.org/>pay day loan</a> ’
by お名前(必須) (2017-09-29 01:27) 

お名前(必須)

online payday loans direct lenders
<a href="https://loansbtxsa.org/">quick loans</a>
are online payday loans
<a href=https://loansbtxsa.org/>online payday loan</a> ’
by お名前(必須) (2017-09-29 08:36) 

お名前(必須)

payday loan no credit check
<a href="https://paydaytbukl.org/">cash advance loans</a>
freedom debt relief reviews
<a href=https://paydaytbukl.org/>payday advance loans</a> ’
by お名前(必須) (2017-09-29 10:13) 

お名前(必須)

open online bank account
<a href="https://cashshybn.com/">cash advance loans</a>
cash loans bad credit
<a href=https://cashshybn.com/>payday loans online</a> ’
by お名前(必須) (2017-09-29 11:39) 

お名前(必須)

absolutely no fax payday loan
<a href="https://paydayvrvi.org">cash advance online</a>
bad credit personal installment loan
<a href=https://paydayvrvi.org>cash advance loans</a> ’
by お名前(必須) (2017-10-01 06:49) 

お名前(必須)

a payday loan lender
<a href="https://cashadvanceamericavatn.org">cash advance usa</a>
check cash
<a href=https://cashadvanceamericavatn.org>cash advance loan</a> ’
by お名前(必須) (2017-10-01 07:56) 

FvrcIdeadaHZ

instant online payday loan
<a href="https://cashadvanceamericasev.org">payday loans no credit check</a>
personal loan low interest
<a href=https://cashadvanceamericasev.org>cash advance inc</a> ’
by FvrcIdeadaHZ (2017-10-01 14:07) 

vwqeCheabsYZ

consolidate debt
<a href="https://installmentloanvelam.com">installment loan</a>
1 hour payday loans
<a href=https://installmentloanvelam.com>instant payday loans</a> ’
by vwqeCheabsYZ (2017-10-01 14:21) 

お名前(必須)

australian payday loans
<a href="https://personalloansntui.com">personal loan bad credit</a>
consolidate student loans
<a href=https://personalloansntui.com>personal loan rates</a> ’
by お名前(必須) (2017-10-01 15:04) 

お名前(必須)

cialis low cost - http://cialisofkl.com/
cialis india <a href=http://cialisofkl.com/>buy cialis</a> ’
by お名前(必須) (2017-10-02 06:47) 

お名前(必須)

buy cialis 20mg - http://cialisovnnc.com/
cialis uk pharmacy <a href=http://cialisovnnc.com/>buy cialis</a> ’
by お名前(必須) (2017-10-03 06:54) 

お名前(必須)

payday cash advance
<a href="https://paydayllae.com/">pay day loan</a>
poor credit personal loans
<a href=https://paydayllae.com/>pay day loan</a> ’
by お名前(必須) (2017-10-03 23:33) 

お名前(必須)

same day personal loans
<a href="https://cashnowemr.com">loans payday</a>
online loans bad credit
<a href=https://cashnowemr.com>fast payday loan</a> ’
by お名前(必須) (2017-10-04 08:03) 

お名前(必須)

debt
<a href="https://cashadmme.com/">payday loan lenders</a>
buy payday loan leads
<a href=https://cashadmme.com/>Cash Advance</a> ’
by お名前(必須) (2017-10-04 09:35) 

JtnbIdeadaRF

cash loan no credit check
<a href="https://paydayloamec.com/">payday loans</a>
auto payday loan
<a href=https://paydayloamec.com/>payday loans online</a> ’
by JtnbIdeadaRF (2017-10-04 16:59) 

お名前(必須)

no fax no teletrack payday loans - https://paydayllae.com/
get personal loan bad credit <a href=https://paydayllae.com/>fast payday loans</a> ’
by お名前(必須) (2017-10-05 07:22) 

お名前(必須)

branded cialis drugstore - https://cheapcheapcialis.com/
purchase cialis professional <a href=https://cheapcheapcialis.com/>cialis online</a> ’
by お名前(必須) (2017-10-07 00:20) 

お名前(必須)

quick loans bad credit - https://cashcevth.com
payday america <a href=https://cashcevth.com>online payday loan</a> ’
by お名前(必須) (2017-10-07 07:45) 

お名前(必須)

bad credit auto loans - https://paydayloansrvhj.com/
credit card debt consolidation <a href=https://paydayloansrvhj.com/>payday loans near me</a> ’
by お名前(必須) (2017-10-07 09:02) 

お名前(必須)

cialis cost australia - https://genericgenericcialis.com/
cialis soft tab <a href=https://genericgenericcialis.com/>cialis buy</a> ’
by お名前(必須) (2017-10-07 10:54) 

お名前(必須)

cheapest cialis online
<a href="https://onlineonlinecialis.com/">buy cialis</a>
free cialis sample pack
<a href=https://onlineonlinecialis.com/>generic cialis</a> ’
by お名前(必須) (2017-10-08 06:39) 

お名前(必須)

debt reduction services
<a href="https://paydayloawdcr.com/">best online payday loans</a>
easy loans bad credit
<a href="https://paydayloawdcr.com/">pay day loan</a> ’
by お名前(必須) (2017-10-08 06:39) 

お名前(必須)

cialis everyday
<a href="https://cheapcheapcialis.com/">cialis 100mg</a>
buy generic cialis in canada
<a href=https://cheapcheapcialis.com/>cialis 100mg</a> ’
by お名前(必須) (2017-10-08 07:52) 

お名前(必須)

same day payday loans
<a href="https://cashecbya.com/">instant payday loans</a>
payday loans no credit check online
<a href=https://cashecbya.com/>payday loan</a> ’
by お名前(必須) (2017-10-09 08:57) 

お名前(必須)

cialis in canada - http://buycialis-menedpil.com/
cialis prescriptions <a href="http://buycialis-menedpil.com/">buy cheap cialis</a> ’
by お名前(必須) (2017-10-11 04:33) 

お名前(必須)

cialis without prescription overnight - http://onlinecialis-cialisvip.com
cialis dosage 10mg <a href=http://onlinecialis-cialisvip.com>cialis</a>
by お名前(必須) (2017-10-11 13:30) 

お名前(必須)

24 hour cialis - http://cialisonline-pricepil.com/
canadian drug cialis <a href=http://cialisonline-pricepil.com/>order cialis online</a> ’
by お名前(必須) (2017-10-11 13:32) 

AqrhdatommaDI

buy cialis 20mg price - http://genericcialis-viaed.com/
cialis canada pharmacy <a href=http://genericcialis-viaed.com/>generic cialis online</a> ’
by AqrhdatommaDI (2017-10-11 23:40) 

お名前(必須)

cialis samples free
<a href="http://buycialis-menedpil.com/">cialis how it works</a>
cialis tablets for sale
<a href="http://buycialis-menedpil.com/">cialis online</a> ’
by お名前(必須) (2017-10-12 07:28) 

お名前(必須)

cialis cost australia
<a href="http://cialisonline-pricepil.com/">cheapest cialis</a>
buy brand cialis from supplier
<a href=http://cialisonline-pricepil.com/>cheap cialis</a> ’
by お名前(必須) (2017-10-12 15:58) 

お名前(必須)

cialis canada no prescription
<a href="http://onlinecialis-cialisvip.com">generic cialis</a>
2.5mg cialis
<a href=http://onlinecialis-cialisvip.com>buy cheap cialis</a> ’
by お名前(必須) (2017-10-12 16:00) 

お名前(必須)

canadian online payday loans - https://loanscerj.com/
instant payday loan no credit <a href=https://loanscerj.com/>speedy cash</a> ’
by お名前(必須) (2017-10-18 14:11) 

お名前(必須)

personal loans poor credit - https://loansnerc.org/
free checking account banks <a href=https://loansnerc.org/>online payday loans</a> ’
by お名前(必須) (2017-10-18 15:41) 

お名前(必須)

online loan - https://loansnzyr.com/
advances <a href=https://loansnzyr.com/>payday loans online</a> ’
by お名前(必須) (2017-10-18 21:19) 

お名前(必須)

500 payday loan
<a href="https://paydayobns.com/">payday loans online</a>
credit repair
<a href="https://paydayobns.com/">loans payday</a> ’
by お名前(必須) (2017-10-19 06:32) 

お名前(必須)

payday loans direct lenders
<a href="https://paydayceinf.org/">payday loan</a>
biggest cash payday loans
<a href=https://paydayceinf.org/>payday loans</a> ’
by お名前(必須) (2017-10-19 06:32) 

お名前(必須)

best payday loan lender - https://loans7foal.com/
online check advance <a href=https://loans7foal.com/>pay day loans</a> ’
by お名前(必須) (2017-10-19 07:31) 

お名前(必須)

help debt consolidation loan
<a href="https://loans7foal.com/">3 month payday loans</a>
fast payday loan
<a href=https://loans7foal.com/>payday loans</a> ’
by お名前(必須) (2017-10-20 11:06) 

お名前(必須)

get installment loan
<a href="https://loanenav.net/">payday loans online</a>
open bank account
<a href=https://loanenav.net/>payday loans</a> ’
by お名前(必須) (2017-10-20 18:29) 

お名前(必須)

lowest price cialis - http://pillsme.com/
buy generic cialis online <a href="http://pillsme.com/">Tadalafil Online</a> ’
by お名前(必須) (2017-10-21 01:15) 

お名前(必須)

cialis doses - http://509pharma.com
purchase cialis <a href=http://509pharma.com>cialis online</a> ’
by お名前(必須) (2017-10-21 09:47) 

お名前(必須)

cialis dosage - http://genericcialis-edviaprx.com/
cialis online buy <a href="http://genericcialis-edviaprx.com/">cialis 20mg</a> ’
by お名前(必須) (2017-10-24 07:41) 

お名前(必須)

cialis alcohol - http://onlinecialis-cialisceo.com/
cialis low dose price <a href=http://onlinecialis-cialisceo.com/>cialis side effects</a> ’
by お名前(必須) (2017-10-24 15:54) 

FfbvgprailiDL

buy cialis online canada
<a href="http://buycialis-menrxonil.com/">buy cheap cialis</a>
cialis.com
<a href=http://buycialis-menrxonil.com/>buy cialis</a> ’
by FfbvgprailiDL (2017-10-26 10:00) 

お名前(必須)

payday loan lenders - http://personalloanvryn24.org/
no credit check online payday loans <a href="http://personalloanvryn24.org/">cash advance on credit card</a> ’
by お名前(必須) (2017-10-30 22:34) 

お名前(必須)

bad credit payday loans in - https://www.jk2paydayloans.org
small loans bad credit <a href=https://www.jk2paydayloans.org>online loans</a> ’
by お名前(必須) (2017-10-30 23:38) 

お名前(必須)

cash advances payday loan - https://cashadmme.com
payday loans no credit check <a href=https://cashadmme.com>need cash now</a> ’
by お名前(必須) (2017-11-01 09:07) 

お名前(必須)

buy payday loan leads - https://installmentsloansjnax.org
fast cash payday loans online <a href=https://installmentsloansjnax.org>short term loan</a> ’
by お名前(必須) (2017-11-03 06:10) 

お名前(必須)

personal loan low interest - http://installmentloanspersonalloandfgd.org
small payday loans <a href=http://installmentloanspersonalloandfgd.org>loans online</a> ’
by お名前(必須) (2017-11-04 06:05) 

お名前(必須)

cheap cialis brand name
<a href="http://cialisovnsm.com/">cialis online</a>
cialis 2.5mg price
<a href=http://cialisovnsm.com/>cialis generic</a> ’
by お名前(必須) (2017-11-04 21:51) 

お名前(必須)

generic soft tabs cialis
<a href="http://cialisovnsm.com/">cialis no prescription</a>
soft cialis tabs
<a href=http://cialisovnsm.com/>discount cialis</a> ’
by お名前(必須) (2017-11-06 07:07) 

お名前(必須)

buy cialis in canada
<a href="http://cialisovnsm.com/">cialis reviews</a>
cheap liquid cialis
<a href=http://cialisovnsm.com/>order cialis</a> ’
by お名前(必須) (2017-11-07 08:30) 

お名前(必須)

cialis no prescription canada
<a href="http://cialisovnsm.com/">cialis soft tabs</a>
cialis order
<a href=http://cialisovnsm.com/>order cialis</a> ’
by お名前(必須) (2017-11-08 20:56) 

お名前(必須)

generic cialis canada
<a href="http://newgenericrx1pricev.com">cialis for sale</a>
cialis professional uk
<a href=http://newgenericrx1pricev.com>cheapest cialis</a> ’
by お名前(必須) (2017-11-09 07:04) 

お名前(必須)

cialis canada online
http://genericcialisienxprice.com/
purchase cialis professional
<a href="http://genericcialisienxprice.com/">cialis</a>
cialis free trial offer
by お名前(必須) (2017-11-10 16:11) 

お名前(必須)

cialis for order
http://cialisonlinednabpill.com/
ordering cialis online
<a href=http://cialisonlinednabpill.com/>buy cheap cialis</a>
cialis taken by women
by お名前(必須) (2017-11-11 16:51) 

お名前(必須)

how much is cialis
http://buycialisenahonlined.com/
buy cialis 10mg
<a href=http://buycialisenahonlined.com/>cialis online</a>
buy discount cialis
by お名前(必須) (2017-11-13 01:49) 

お名前(必須)

buy cialis soft
http://cialisonlinednabpill.com/
cialis samples free
<a href=http://cialisonlinednabpill.com/>generic cialis</a>
cheap cialis professional
by お名前(必須) (2017-11-13 02:25) 

お名前(必須)

canadian generic cialis
http://genericcialisienxprice.com/
buy discount cialis
<a href=http://genericcialisienxprice.com/>]cialis generic</a>
cialis samples
by お名前(必須) (2017-11-13 04:04) 

コメントを書く

お名前:
URL:
コメント:
画像認証:
下の画像に表示されている文字を入力してください。

トラックバック 0

この広告は前回の更新から一定期間経過したブログに表示されています。更新すると自動で解除されます。

×

この広告は1年以上新しい記事の更新がないブログに表示されております。