SQL查询表结构

--SQLServer以表bs_location为例
select name from syscolumns 
where id = object_id('bs_location') 

--MySQL以表bs_location为例
select column_name from information_schema.columns 
where table_name='bs_location' 

--SQLite以表bs_location为例
pragma table_info('bs_location')