对SQL表结构的查询
作者:IT科技类资讯 来源:IT科技 浏览: 【大中小】 发布时间:2025-11-05 08:52:40 评论数:
复制if exists (select * from sysobjects where id = object_id(dbo. print_dbstructure ) and sysstat & 0xf = 4) 存储过程 drop procedure dbo. print_dbstructureGO CREATE PROCEDURE print_dbstructureAS SELECT DISTINCT sysobjects.name,表结 syscolumns.colid, syscolumns.name, systypes.name, syscolumns.prec, syscolumns.scale FROM syscolumns, sysobjects, systypes WHERE sysobjects.id = syscolumns.id AND systypes.type = syscolumns.type AND ((sysobjects.type=u)) GO 1.2.3.4.5.6.7.8.9.10.