You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
In this article I show how to determine how many types of entities you have in your any database.
Get the number of Tables, Stored Procedures, Triggers, Functions and so on in your database. In this article I will tell how you can determine how many types of entities you have in your any database, like:
There is a system view named "sysobjects" in every database by which you can get the list of every kind of entity that exists in your databse.To check it, expand your database then "Views" and then expand "System Views" like here the databse name is "Test".
The following are all the types of entities in the sysobjects view:
AF = Aggregate function (CLR)C = CHECK constraintD = DEFAULT (constraint or stand-alone)F = FOREIGN KEY constraintFN = SQL scalar functionFS = Assembly (CLR) scalar-functionFT = Assembly (CLR) table-valued functionIF = SQL inline table-valued functionIT = Internal tableP = SQL Stored ProcedurePC = Assembly (CLR) stored-procedurePG = Plan guidePK = PRIMARY KEY constraintR = Rule (old-style, stand-alone)RF = Replication-filter-procedureS = System base tableSN = SynonymSO = Sequence objectSQ = Service queueTA = Assembly (CLR) DML triggerTF = SQL table-valued-functionTR = SQL DML trigger TT = Table typeU = Table (user-defined)UQ = UNIQUE constraintV = ViewX = Extended stored procedure
Introducing Microsoft SQL Server 2016