select column_name,data_type, table_name from information_schema.columns
where table_name in (select Name from sysobjects where xtype='u' and status>=0)
list all column info
最新推荐文章于 2023-03-31 08:57:29 发布
select column_name,data_type, table_name from information_schema.columns
where table_name in (select Name from sysobjects where xtype='u' and status>=0)