>I am looking for a function in SQL server similar to ADIR() in foxpro.
>
>Does any body know how to get information about files into an array and then returns the name of the files.
>
>
>Thanks,
>Sergio
SELECT DISTINCT Table_Name FROM
YourdatabaseName.INFORMATION_SCHEMA.COLUMNS
ORDER BY Table_Name
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst