SQLServer
There are 3 functions which are used to query metadata from SQL Server databases.
sp_tables
sp_columns
sp_stored_procedures
There do take parameters to filter the data being queried based on certain criteria.
Tips for AWS, BIG DATA, JAVA, J2EE, INTERVIEWS, HADOOP, HDFS, SPARK