CODEWITHSUNDEEP
sqlsql-server
user11606636
user11606636

Reputation: 1

Trying to get the relevant details of all the database

I am trying to get everything 

find all the tables, views, stored procedures, scalar functions, table functions, schema using sql query of a specific database

I actually wanted to create a autocomplete option but as of now my first step is to get everything in a list but not sure how i will get all of the above of a specific database

Upvotes: 0

Views: 28

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270001

This is a bit long for a comment.

You need to look into the system tables. Personally, I prefer the standard INFORMATION_SCHEMA views, but the information you want is spread out.

In SQL Server, you can use sys.objects, paying attention to the object type. The place to start learning about it is in the documentation.

Upvotes: 1

Related Questions