Tuesday, September 11, 2007

Find table name, columns name in sql server

Find table name, columns name in sql server

select TABLE_NAME, COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

order by TABLE_NAME, ORDINAL_POSITION

No comments: