SharePoint 2016文档库所在数据库表的说明（文档库数据库）

SharePoint 2016文档库所在数据库表的说明（文档库数据库）

突然被客户问一个问题，说数据库存在哪一个表，这个原本是开发的事，竟然文档我了，好吧这里记录一下，以便记忆给客户汇报。

SharePoint 数据库表说明：

Features	Table that holds information about all the activated features for each site collection or site.
Sites	Table that holds information about all the site collections for this content database.
Webs	Table that holds information about all the specific sites (webs) in each site collection.
UserInfo	Table that holds information about all the users for each site collection.
Groups	Table that holds information about all the SharePoint groups in each site collection.
Roles	Table that holds information about all the SharePoint roles (permission levels) for each site.
All Lists	Table that holds information about lists for each site.
GroupMembership	Table that holds information about all the SharePoint group members.
AllUserData	Table that holds information about all the list items for each list.
AllDocs	Table that holds information about all the documents (and all list items) for each document library and list.
RoleAssignment	Table that holds information about all the users or SharePoint groups that are assigned to roles.
Sched Subscriptions	Table that holds information about all the scheduled subscriptions (alerts) for each user.
ImmedSubscriptions	Table that holds information about all the immediate subscriptions (alerts) for each user.

Alldocs 说明

https://msdn.microsoft.com/en-us/library/hh656481(v=office.12).aspx

所有表位置：

如下表分别存储文档库不同的内容；

select * from [sysobjects] where [type] = 'u' and name like '%doc%' order by [name]

查找方式

select top 10 * from AllDocs a, DocStreams d where d.docID = a.ID
select top 10 * from [dbo].[DocsToStreams]
select top 10 * from [dbo].[DocStreams]
select top 10 * from [dbo].[DocVersionEvents]


select * from [sysobjects] where [type] = 'u' and name like '%doc%' order by [name]

效果

关于Sharepoint 数据库的问题，请参考：https://technet.microsoft.com/library/cc678868

ms sql server

1、查询所有表
select [id], [name] from [sysobjects] where [type] = 'u' order by [name]
2、查询所有数据库
3、select [name] from [sysdatabases] order by [name]
查询表中字段
select [name] from [syscolumns] where [name] = 'tableXXX'order by [colid]

oracle

1、查找表的所有索引（包括索引名，类型，构成列）：

select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = 要查询的表

2、查找表的主键（包括名称，构成列）：

select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = 要查询的表

3、查找表的唯一性约束（包括名称，构成列）：

select column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'U' and au.table_name = 要查询的表

4、查找表的外键（包括名称，引用表的表名和对应的键名，下面是分成多步查询）：

select * from user_constraints c where c.constraint_type = 'R' and c.table_name = 要查询的表

查询外键约束的列名：

select * from user_cons_columns cl where cl.constraint_name = 外键名称

查询引用表的键的列名：

select * from user_cons_columns cl where cl.constraint_name = 外键引用表的键名

5、查询表的所有列及其属性

select t.*,c.COMMENTS from user_tab_columns t,user_col_comments c where t.table_name = c.table_name and t.column_name = c.column_name and t.table_name = 要查询的表

6、查询所有表
select* from tabs

SharePoint 所有数据库说明

一、WSS_Content

后端内容数据库存储所有网站内容，包括网站的文档或文档库中的文件，列表数据和Web部件属性，以及用户名和权限。 为特定网站的所有数据的内容数据库。

二、SharePoint_Config

配置数据库句柄的所有管理部署，请求定向到相应的数据库和管理后端数据库的负载平衡。 在前端