files in sql

[nisha]

If anybody knows can you please let me know how to view the files in sql server

[rmiao]

Files stored in sql table as image data? Need third party tools.

[nisha]

can you elaborate it plz. I faced this question in an interview.

[rmiao]

You didn't give me details yet.

[nisha]

if we want to see the files that are present in sql server how we can see the files and directories.

[nosepicker]

I think you're looking for this:

SELECT * FROM master..sysaltfiles

[nisha]

Thanks. Is there any way to see the files and directories present in particular server.

[rmiao]

Query master..sysdatabases table.

[nisha]

Can you please tell me the difference between these two.
select * from master..sysdatabases
select * from master..sysaltfiles

[rmiao]

sysdatabases gives you more db info in the instance, while sysaltfiles gives you more db files info.

[nisha]

Thanks. I am looking for the file info in the database