Skip to main content



  1. Aggregate Function: Get the name of all Aggregate functions.

    Select name,type from sysobjects where type='AF'
  2. Foreign Key: Get the name of all Foreign Keys.

    Select name,type from sysobjects where type='F'
  3. Function: Get the name of all scalar functions.

    Select name,type from sysobjects where type='FN'
  4. Stored Procedure: Get the name of all Stored Procedures. 

    Select name,type from sysobjects where type='P'
  5. Primary Key: Get the name of all Primary Keys.

    Select name,type from sysobjects where type='PK'
  6. Table-Valued-Function: Get the name of all Aggregate functions.

    Select name,type from sysobjects where type='TF'
  7. Trigger: Get the name of all DML triggers.

    Select name,type from sysobjects where type='TR'
  8. Tables: Get the name of all Tables (user-defined).

    Select name,type from sysobjects where type='U'
  9. View: Get the name of all Views.

    Select name,type from sysobjects where type='V'
The following are all the types of entities in the sysobjects view:
AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SO = Sequence object
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger 
TT = Table type
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended stored procedure


Popular posts from this blog

WhatsApp to release Dark Theme for Android beta testers

WhatsApp has recently submitted a new update through the Google Play Beta Program , bringing the version up to 2.20.13. This update contains, finally, a very important Dark Theme If you have installed the update, the  Dark Theme  might be available for you: check out  WhatsApp Settings > Chats Screenshot for Reference

T@M!L Tech Privacy Policy

T@M!L Tech Privacy Policy This privacy policy has been compiled to better serve those who are concerned with how their  'Personally Identifiable Information' (PII) is being used online. PII, as described in US privacy law and  information security, is information that can be used on its own or with other information to identify,  contact, or locate a single person, or to identify an individual in context.  Please read our privacy policy carefully to get a clear understanding of how we collect, use,  protect or otherwise handle your Personally Identifiable Information in accordance with our website. What personal information do we collect from the people that visit our blog, website or app? We do not collect information from visitors of our site. own data or other details to help you with your experience. When do we collect information? We collect information from you when you register on our site or enter information on our site. How do we use y

WhatsApp finally brings fingerprint authentication to Android beta users

The long awaited feature has made its way to a stable WhatsApp beta build for Android You can activate the functionality by tapping on the hamburger menu (three dots on the top right corner) and then selecting  Settings>Account>Privacy>Fingerprint lock