Tuesday, February 2, 2010

Getting list of Fields and associated information from a Table


ShareThis
Getting list of Fields and associated information from a Table (in SQL server) also called table schema:

select column_name,* from information_schema.columns
where table_name = 'TaxiMaster'
order by ordinal_position

0 comments: