Please provide a list of SQL Database Objects

curiouswebster
curiouswebster used Ask the Experts™
on
Please provide a list of SQL Database Objects

I am curious about whether "SQL Database Objects" makes you think of scripts, stored procedures, functions, views and triggers. Or, if there is a set of objects I may have not worked with yet.

Please confirm that those which I listed are in fact "SQL Database Objects" or list any that come to mind.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
For starters, give this a whirl..

USE {database name goes here}
GO

SELECT name, type_desc, type
FROM sys.objects o
WHERE type NOT IN ('S', 'IT', 'PK', 'F', 'D', 'SQ') 
ORDER BY type_desc, name

Open in new window


>Please confirm that those which I listed are in fact "SQL Database Objects" or list any that come to mind.
No idea what this means.
curiouswebsterSoftware Engineer

Author

Commented:
Thanks for the cool query.

Attached is an Excel of the results.

What are the meaning of those which you excluded?

'S'
'IT'
'PK'
'F'
'D'
'SQ'

If FN, a Scalar Function, is a normal database function, then I have worked with FN, P, TR, U and V. But, as far as I know, have not worked with C, IF.

Is FN a normal database function? A function which accepts one parameter and returns one parameter?

Thanks for your insight!
DatabaseObjects.xlsx
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Ryan ChongSoftware Team Lead
Commented:
curiouswebsterSoftware Engineer

Author

Commented:
.
curiouswebsterSoftware Engineer

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial