T@M!L Tech

SQL DATABASE DETAIL QUERY Aggregate Function:  Get the name of all Aggregate functions. S elect  name , type   from   sysobjects   where   type = 'AF'   Foreign Key : Get the name of all Foreign Keys. S elect  name , type   from   sysobjects   where   type = 'F'   Function:  Get the name of all scalar functions. S elect  name , type   from   sysobjects   where   type = 'FN'   Stored Procedure:  Get the name of all Stored Procedures.  S elect  name , type   from   sysobjects   where   type = 'P'   Primary Key:  Get the name of all Primary Keys. S elect  name , type   from   sysobjects   where   type = 'PK'   Table-Valued-Function:  Get the name of all Aggregate functions. S elect  name , type   from   sysobjects   where   type = 'TF'   Trigger:  Get the name of all DML triggers. S elect  name , type   from   sysobjects   where   type = 'TR'   Tables:  Get the name of all Tables (user-defined). S elect  name , type   from