Skip to main content

GET THE DETAIL OF SQL DATABASE

SQL DATABASE DETAIL QUERY

  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

Comments

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
Upgrade/Update HTC Desire 816G Dual Sim To Android 6.0 Marshmallow  The Android 6.0 Marshmallow comes with various advantages and features, but the obvious one is the performance improvement. The new OS offer up to 4 times of performance improvements, along with faster and more powerful computing. Google also claimed that the Android 6.0 Marshmallow can extend your device’s battery life by up to 90 minutes. It’s a must-have upgrade for every HTC Desire 816G Dual Sim owners!  Before you upgrade your device, there are some things you need to consider. First is you should back up all of your personal data on your smartphone. You also have to enable the USB Debugging is enabled. Last but not least, it is highly recommended to have the HTC Desire 816G Dual Sim fully charged. Therefore, you can be sure that the phone can stay on during the whole process. How to Install Android 6.0 Marshmallow ROM on HTC Desire 816G Dual Sim   Video Tutorial Download ROM Part 1 :

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