TableInfo
来源:互联网 发布:大数据4v特征 编辑:程序博客网 时间:2024/05/17 00:16
create VIEW [dbo].[TableInfo]
AS
SELECT DISTINCT
obj.name AS TableName, col.colid AS ColumnIndex, col.name AS ColumnName, scol.DATA_TYPE, col.length AS ColumnLength, CONVERT(varchar(500),
ISNULL(prop.value, N' ')) AS ColumnDesc
FROM sys.sysobjects AS obj INNER JOIN
sys.syscolumns AS col ON col.id = obj.id INNER JOIN
INFORMATION_SCHEMA.COLUMNS AS scol ON scol.TABLE_NAME = obj.name AND scol.COLUMN_NAME = col.name LEFT OUTER JOIN
sys.extended_properties AS prop ON prop.major_id = obj.id AND prop.minor_id = col.colid AND prop.name = 'MS_Description'
GO
- TableInfo
- ActiveAndroid TableInfo TypeSerializer
- scanning for model in Activeandroid—TableInfo TypeSerializer
- Attempt to invoke virtual method 'java.lang.String com.activeandroid.TableInfo.getIdName()' on a nul
- 打图钉
- MFC操作——右键弹出菜单事件
- 使用JMF进行视频、音频的采集与实时传送
- Vmware ESX 5.0 安装与部署 .
- XPath语法在C#中使用XPath示例第二讲
- TableInfo
- HDU 1195 OPEN THE LOCK
- ARM架构
- 【大树下感悟】活着,就是学习思考分享!
- 获取软件版本号和版本名
- RGB颜色查询对照表
- 爱、就疯狂、不爱、就坚强,你还相信爱情么
- 把Oracle 11g 字符集WE8MSWIN1252换成UTF8
- mac Xib中的控件无法调整其位置