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

0 vote387 views1 answer
Distance calculator from lat long sql query
SQL
3 votes394 views1 answer
Laravel paginate raw sql
SQL
1 vote358 views1 answer
How do you use sql in you company
SQL
1 vote384 views1 answer
Backup mysql schema only
SQL
2 votes366 views1 answer
Search query in mysql
SQL
2 votes379 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote303 views1 answer
Mysql convert column to uppercase
SQL
7 votes340 views1 answer
Safe mode mysql
SQL
0 vote332 views1 answer
SQL get max per id
SQL
0 vote386 views1 answer
Dual in db2
SQL