Select * from sysfiles : sysfiles « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sysfiles
4> CREATE PROC sp_list_files_and_objects
5> AS
6> SELECT filename FROM sysfiles
7> SELECT name from sysobjects
8> RETURN
9> GO
1>
2> drop PROC sp_list_files_and_objects;
3> GO
1>








27.29.sysfiles
27.29.1.Select * from sysfiles