select Columns,Tables
来源:互联网 发布:人人商城v3小程序源码 编辑:程序博客网 时间:2024/05/23 17:39
SELECT TOP 100 PERCENT c.colid AS 序号, o.name AS 表名, c.name AS 列名,
t.name AS 类型, c.length AS 长度, c.isnullable AS 允许空,
CAST(m.[value] AS Varchar(100)) AS 说明
FROM dbo.syscolumns c INNER JOIN
dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, N'IsUserTable') = 1 AND
o.name <> 'dtproperties' INNER JOIN
dbo.systypes t ON t.xusertype = c.xusertype LEFT OUTER JOIN
dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorder
ORDER BY o.name, c.colid
t.name AS 类型, c.length AS 长度, c.isnullable AS 允许空,
CAST(m.[value] AS Varchar(100)) AS 说明
FROM dbo.syscolumns c INNER JOIN
dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, N'IsUserTable') = 1 AND
o.name <> 'dtproperties' INNER JOIN
dbo.systypes t ON t.xusertype = c.xusertype LEFT OUTER JOIN
dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorder
ORDER BY o.name, c.colid
- select Columns,Tables
- SELECT * FROM information_schema.columns
- Stored procedures 1: Find columns and tables
- Stored procedures: Find columns and tables
- System.columns, System.objects, System.tables
- 关于mysql中的information_schema.tables和information_schema.columns详解
- The used SELECT statements have a different number of columns
- select * from information_schema.tables 查询所有表
- Find Text in all columns of all tables in a Database
- ORA-22804: remote operations not permitted on object tables or user-defined type columns
- Using CREATE TABLE AS SELECT (CTAS) to Reorganize Oracle Tables
- ORACLE ORA-02030: can only select from fixed tables/views
- Tables used within report and the associated select statement:
- Magento: Join, filter, select and sort attributes, fields and tables
- ORACLE ORA-02030: can only select from fixed tables/views
- ORACLE ORA-02030: can only select from fixed tables/views
- ORA-02030: can only select from fixed tables/views
- ORACLE ORA-02030: can only select from fixed tables/views
- String类使用心得(希望大家有什么心得也回复出来,本人一并整理共享)
- [研究报告]侯总迅速蹿红现象研究报告
- 为什么无法面向对象
- 词典存储结构分析
- 郁闷资源得不到有效的积累
- select Columns,Tables
- shell内部变量和全局变量
- Shell函数执行结果和退出状态
- 垃圾邮件防火墙推荐使用的DNS
- 汉日词典结构的研究(一)---源语言分析
- 使用firefox+gspace+GMail组成超级U盘
- jquery 点即可编辑插件
- 转载 DIALOG使用技巧
- 资源收藏