caim的专栏

SQLServer查询一个表的字段定义信息declare @table_name as varchar(max)declare @table_id as varchar(max)set @table_name='tb_test' -- 把 tb_test 替换为要查询的表名select @table_id=object_id from sys.tables where name=@table_name select @table_name table_name, a.name column