1. How to get list of stored procedures in a database
2. How to get list of tables in a database
3. How to get list of databases in a SQL server
SELECT NAME FROM SYS.ALL_OBJECTS WHERE type= 'P'
2. How to get list of tables in a database
SELECT * from sysobjects where type = 'U'
3. How to get list of databases in a SQL server
SELECT name, collation_name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')
Thank you for your post. This is superb information. It is amazing and great to visit your site.
ReplyDeleteevs full form
raw agent full form
full form of tbh in instagram
dbs bank full form
https full form
tft full form
pco full form
kra full form in hr
tbh full form in instagram story
epc full form