查看数据库中表、视图等
时间：2010-09-10 来源：缘分星空
<HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看数据库中表、视图等</title>
<!-- #INCLUDE FILE="ADOVBS.INC" -->
</head>
<body>
<%
Dim Conn
Dim RS
Set Conn = Server.CreateObject("ADODB.Connection")
Dim connstr
connstr = "DBQ="+server.mappath("webdb.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;"
'connstr = "DSN=Sql;UID=sa;PWD=;DATABASE=master"
Conn.CursorLocation = adUseClient
Conn.Open connstr
Set RS = Conn.OpenSchema(adSchemaTables)
%>
<div align="center"><center>
<table border="1">
<tr>
<td>库名</td>
<td>表名</td>
<td>所有者</td>
<td>类型</td>
<td>描述</td>
</tr>
<%
Do Until RS.EOF
%>
<tr>
<td><% = RS("TABLE_CATALOG") %></td>
<td><% = RS("TABLE_NAME") %></td>
<td><% = RS("TABLE_SCHEMA") %></td>
<td><% = RS("TABLE_TYPE") %></td>
<td><% = RS("DESCRIPTION") %></td>
</tr>
<%
RS.MoveNext
Loop
%>
</table>
</center></div>
<p>在ACCESS、Microsoft sql server、IIS4、PWS4中均可运行。<br>
还有一个更直观的办法哟，就是直接用SQL语句<br>
Access: select * from MSysObjects;<br>
SQL Server: select * from dbo.sysobjects<br>
Oracle: select * from tab;<br>
不过如果你不加限制条件的话，就会一股脑儿把存储结构呀，模块呀什么的全都查出来了<br>
露茜 1999年1月17日</p>
</body>
</html>
royal caribbean crusechanel 2009south beach apartment rentalsjane blonde dd7motorcycle leather jackets womenland leather shopscelebrity cruises san franciscorunway fashion picturesfire screensaverangie stone cdmonogrammed gold necklacesdesigner purse handbagasia cruise selfish videomongrammed pursesnew cruise shipsdiscount handbags pricesnorwegian gem mediterranean cruiseluggage set priceslin fang guoweincl cruise specialmen bathrobehandmade handbagswheeled backpackcelebrity cruise official siteChanel-6282-BLUEcrystal beach condostree nurseriesclassic messenger bagskids messenger backpackreplay jeansriddles and jokemen leather winter glovescruises new yorkchiffon square scarfcustomised rubber stampsbest mexico vacation spotsleather wallet keychainheys xcase 20 inch carry on luggagetooled leather belt reviewcheap briefcasetravelon portable luggage scalecruise line security jobscruise deals princessdsquared jacket manufacturersGucci-203494-03beech house hotel yorkdesigners handbagprices canvaspictures oil on canvasbuy louis vuitton bags onlinezack cody big daddybest cruise family 5fringed leather vestbelize mapmarc jacobs shoes salefendi wallets womenlocal delivery driversalsa cruise asia 2009briefcase handbagsleather kids jacketsatchel handbags salescale jokesdsquared 2009guess jeans onlinecarry on restrictionsblue pleated skirtmens leather travel bagsfairport harbor beachfree monogram embroideryscarf tying ideascustomized bic penssouth beach days inndior ukamerican discount cruisescelebrity cruise south americaamerican cruise travelGucci-218192-03heys luggage reviewsrental lease formlist name brand pursesmens surfer necklacesbrown hand bagsisabelt invisible beltisland real estate vacation rentalsbaby shower paper plates napkinshalloween crafts for kindergartenair america cruisewinter craft ideas kidsgiclee equipmentreggae boat partybath towels for kidshomemade halloween craftsmens black denim vest60th birthday gift basketsmexico cityh&m salemonogram wax sealatlantic luggage repair partsbest tote bagstravelocity american expresstie fly fishing knotwater landscape paintingstignanello french tote handbagm missoniphilippine fashion week spring summer 2010impressionist seascapearmani purseanna maria island beachfront rentalsmexico beachfront rentaltooled leather backgroundmacys websitecraft leather boots runescapewalt disney cruisefold napkins dinner partymake gift tagspasajes costa atlanticaamerican sporting goodsleather tote bagselement silvernicoletti furniturelouis xvtennis bags on saledisney world hours aug 2009Gucci-77130-03M95767lrg leather coatsdassault mirage iii airhot winter fashiongreen leather jacketscruise vacations withholland america discount cruisesmotorcycle rain chapsleather lace up dresslarge photo prints on canvasroyal princess photosantique beaded handbagsflamenco dancerdelta airline carry luggage sizetravelocity disneylandvincent van gogh landscapelouis vuitton spring summer 2009automotive spray painttv winterbags etcused luxury handbagstips designer shoesatlantis hotel atlantic beach ncdolce gabbana handbags ebayisland flowersfendi zucca bagsroyal caribbean discount cruisesvintage designer handbagsstretch oil paintingbest travel accessoriesamazon walletsfendi selleria handbagvinyl boat wrapscheap shearling coatssmall leather sectionalproperty sale severn beachrosemary beach hotelstimbuk2 messenger bagshalford hide leather companyreplica designer handbags chinacruises cruise linesone liner jokes freethings remembered graduation giftscheap baseball bagsauthentic marc jacobs handbagswinter backgroundmonogram jeweleryall inclusive cruises onlyroyal caribbean cruise homediscount suitcaseamerican leather incfamily room furniture setN51119princess cruises grand mediterraneanholland america specialsskull scarf patternprincess rolling luggagewolverine bootspreppy monogramsdaniel leather storeGucci-208710-Buletravel channel royal caribbeana dinner cruisemichael kors handbags salecoupon codes executive gift shoppethe seaside innfine art portraitscelebrity cruise pricesauthentic chanel wholesaleholland america cruise ship reviewshandmade handbags totesmonogrammed car decalcurrent vacanciesminiature fastenersfab fashion gameriver cruises asia
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看数据库中表、视图等</title>
<!-- #INCLUDE FILE="ADOVBS.INC" -->
</head>
<body>
<%
Dim Conn
Dim RS
Set Conn = Server.CreateObject("ADODB.Connection")
Dim connstr
connstr = "DBQ="+server.mappath("webdb.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;"
'connstr = "DSN=Sql;UID=sa;PWD=;DATABASE=master"
Conn.CursorLocation = adUseClient
Conn.Open connstr
Set RS = Conn.OpenSchema(adSchemaTables)
%>
<div align="center"><center>
<table border="1">
<tr>
<td>库名</td>
<td>表名</td>
<td>所有者</td>
<td>类型</td>
<td>描述</td>
</tr>
<%
Do Until RS.EOF
%>
<tr>
<td><% = RS("TABLE_CATALOG") %></td>
<td><% = RS("TABLE_NAME") %></td>
<td><% = RS("TABLE_SCHEMA") %></td>
<td><% = RS("TABLE_TYPE") %></td>
<td><% = RS("DESCRIPTION") %></td>
</tr>
<%
RS.MoveNext
Loop
%>
</table>
</center></div>
<p>在ACCESS、Microsoft sql server、IIS4、PWS4中均可运行。<br>
还有一个更直观的办法哟，就是直接用SQL语句<br>
Access: select * from MSysObjects;<br>
SQL Server: select * from dbo.sysobjects<br>
Oracle: select * from tab;<br>
不过如果你不加限制条件的话，就会一股脑儿把存储结构呀，模块呀什么的全都查出来了<br>
露茜 1999年1月17日</p>
</body>
</html>
royal caribbean crusechanel 2009south beach apartment rentalsjane blonde dd7motorcycle leather jackets womenland leather shopscelebrity cruises san franciscorunway fashion picturesfire screensaverangie stone cdmonogrammed gold necklacesdesigner purse handbagasia cruise selfish videomongrammed pursesnew cruise shipsdiscount handbags pricesnorwegian gem mediterranean cruiseluggage set priceslin fang guoweincl cruise specialmen bathrobehandmade handbagswheeled backpackcelebrity cruise official siteChanel-6282-BLUEcrystal beach condostree nurseriesclassic messenger bagskids messenger backpackreplay jeansriddles and jokemen leather winter glovescruises new yorkchiffon square scarfcustomised rubber stampsbest mexico vacation spotsleather wallet keychainheys xcase 20 inch carry on luggagetooled leather belt reviewcheap briefcasetravelon portable luggage scalecruise line security jobscruise deals princessdsquared jacket manufacturersGucci-203494-03beech house hotel yorkdesigners handbagprices canvaspictures oil on canvasbuy louis vuitton bags onlinezack cody big daddybest cruise family 5fringed leather vestbelize mapmarc jacobs shoes salefendi wallets womenlocal delivery driversalsa cruise asia 2009briefcase handbagsleather kids jacketsatchel handbags salescale jokesdsquared 2009guess jeans onlinecarry on restrictionsblue pleated skirtmens leather travel bagsfairport harbor beachfree monogram embroideryscarf tying ideascustomized bic penssouth beach days inndior ukamerican discount cruisescelebrity cruise south americaamerican cruise travelGucci-218192-03heys luggage reviewsrental lease formlist name brand pursesmens surfer necklacesbrown hand bagsisabelt invisible beltisland real estate vacation rentalsbaby shower paper plates napkinshalloween crafts for kindergartenair america cruisewinter craft ideas kidsgiclee equipmentreggae boat partybath towels for kidshomemade halloween craftsmens black denim vest60th birthday gift basketsmexico cityh&m salemonogram wax sealatlantic luggage repair partsbest tote bagstravelocity american expresstie fly fishing knotwater landscape paintingstignanello french tote handbagm missoniphilippine fashion week spring summer 2010impressionist seascapearmani purseanna maria island beachfront rentalsmexico beachfront rentaltooled leather backgroundmacys websitecraft leather boots runescapewalt disney cruisefold napkins dinner partymake gift tagspasajes costa atlanticaamerican sporting goodsleather tote bagselement silvernicoletti furniturelouis xvtennis bags on saledisney world hours aug 2009Gucci-77130-03M95767lrg leather coatsdassault mirage iii airhot winter fashiongreen leather jacketscruise vacations withholland america discount cruisesmotorcycle rain chapsleather lace up dresslarge photo prints on canvasroyal princess photosantique beaded handbagsflamenco dancerdelta airline carry luggage sizetravelocity disneylandvincent van gogh landscapelouis vuitton spring summer 2009automotive spray painttv winterbags etcused luxury handbagstips designer shoesatlantis hotel atlantic beach ncdolce gabbana handbags ebayisland flowersfendi zucca bagsroyal caribbean discount cruisesvintage designer handbagsstretch oil paintingbest travel accessoriesamazon walletsfendi selleria handbagvinyl boat wrapscheap shearling coatssmall leather sectionalproperty sale severn beachrosemary beach hotelstimbuk2 messenger bagshalford hide leather companyreplica designer handbags chinacruises cruise linesone liner jokes freethings remembered graduation giftscheap baseball bagsauthentic marc jacobs handbagswinter backgroundmonogram jeweleryall inclusive cruises onlyroyal caribbean cruise homediscount suitcaseamerican leather incfamily room furniture setN51119princess cruises grand mediterraneanholland america specialsskull scarf patternprincess rolling luggagewolverine bootspreppy monogramsdaniel leather storeGucci-208710-Buletravel channel royal caribbeana dinner cruisemichael kors handbags salecoupon codes executive gift shoppethe seaside innfine art portraitscelebrity cruise pricesauthentic chanel wholesaleholland america cruise ship reviewshandmade handbags totesmonogrammed car decalcurrent vacanciesminiature fastenersfab fashion gameriver cruises asia
Replica lv Hangbags
Replica Hangbags
Hangbags
replica handbags
replica handbags
replica handbags
replica handbags
handbags
handbags
replica handbags
replica handbags
replica handbagsusb cable
usb cable
usb cable
usb cable
usb cable
bag
usb flash drives
usb flash drives
usb flash drives
usb flash drives usb flash drives usb flash drives usb flash drives usb flash drives USB Connector 相关阅读 更多 +
