Object Information

--list all the tables         
SELECT name AS [Tables] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'isUserTable')<>0
--list all the Scalar functions
SELECT name AS [Scalar functions] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsScalarFunction')<>0
--list all the Table Functions
SELECT name AS [Table Functions] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsTableFunction')<>0
--list all the Procedures
SELECT name AS [Procedures] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsProcedure')<>0
--list all the Triggers
SELECT name AS [Triggers] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsTrigger')<>0

Source: red-gate.com

Similar codes

21 votes333 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote351 views1 answer
Get date from timestamp in mysql
SQL
0 vote359 views1 answer
Stored procedures example
SQL
0 vote324 views4 answers
Mysql replace regex
SQL
3 votes529 views6 answers
Sql unique select
SQL
0 vote334 views4 answers
Best data type to represent money in mysql
SQL
4 votes330 views2 answers
Mysql select where starts with
SQL
4 votes353 views1 answer
Id increment ms sql server
SQL
0 vote346 views1 answer
QCompleter con sql
SQL
0 vote326 views1 answer
Update set with inner join oracle
SQL