SQLUSA

Microsoft SQL Server 2005

Best Practices

 

How to SELECT from system tables?

 

System tables are off limit. You can access the corresponding views by placing a period after the "sys". Example:

select * from sys.objects


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page