|
获取Sql Server中的数据库名、表名?、字段名
---------------------------------------------------------------------------------------
1.获取所有数据库名:
SELECT Name FROM Master..SysDatabases ORDER BY Name
2.获取所有表名:
SELECT Name FROM DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':表示所有用户表;
XType='S':表示所有系统表;
3.获取所有字段名:
SELECT Name FROM SysColumns WHERE id=Object_Id('TableName')
?
?
获取ACCESS数据库中的 查询、窗体、表名、报表、模块、宏
---------------------------------------------------------------------------
查询:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name;
窗体:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;
表名:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;
报表:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;
模块:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32761 ORDER BY MSysObjects.Name;
宏:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32766 ORDER BY MSysObjects.Name;
Access所有对象的列表及创建日期、修改日期：
SELECT msysobjects.Name,msysobjects.DateUpdate,msysobjects.DateCreate FROM msysobjects
WHERE (((msysobjects.Type) Like "-3276*" Or (msysobjects.Type)=1 Or (msysobjects.Type)=4 Or (msysobjects.Type)=5) AND ((msysobjects.Flags)=0)) OR (((msysobjects.Flags)=537919488)) ORDER BY msysobjects.Type,msysobjects.Flags
?
通过对数据库的系统表对象来判断网站中使用的是何种数据库格式(SQLServer、ACCESS)
------------------------------------------------------------------------------------------------------------
1、(select count(*) from sysobjects)>=0? 如果查询结果成立,则是使用SQL数据库；
2、(select count(*) from Msysaccessobjects)>=0? 如果查询结果成立,则是ACCESS数据库。
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
