SQL SERVER:
select NAME from syscolumns
where id = OBJECT_ID('表名');所有列名称,
select count(*) from syscolumns
select column_name,data_type from all_tab_columns
where owner='用户名' and table_name='表名';所有列名称
select count(*) from all_tab_columns
where owner='用户名' and table_name='表名';列的数量
select NAME from syscolumns
where id = OBJECT_ID('表名');所有列名称,
select count(*) from syscolumns
where id = OBJECT_ID('表名');列的数量
select column_name,data_type from all_tab_columns
where owner='用户名' and table_name='表名';所有列名称
select count(*) from all_tab_columns
where owner='用户名' and table_name='表名';列的数量