>Hi all,
>
>does anybody know the equivalent of
>
>USE MyTable
>LIST STRUCTURE TO C:\MyTableStructure.txt
>
>in T-SQL?
>
>Thanks in advance!
>
>Hans
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YOUR TABLE NAME HERE'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
