Two more commonly used SQL statements related to SQL Server Fields

Two more commonly used SQL statements related to SQL Server fields -- downmoon:
1. Fields in all user tables can be listed:

-- List all user table fields
Select syscolumns. name colname, sysobjects. name tabname ,*
From sysobjects, syscolumns
Where sysobjects. id = syscolumns. id and sysobjects. xtype = 'U'

2. List all table names with field P_Name

-- List all table names with field P_Name
Select Table name = a. name from vegnet .. sysobjects a join vegnet .. syscolumns B on a. id = B. id
Where B. name = 'P _ name'