Hier fürs Archiv verschiedene SQL-Script Bausteine:
Sich alle Tabellen ausgeben lassen:
DECLARE @curTabellen CURSOR
DECLARE @tabelle nvarchar(200)
SET @curTabellen = CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE (TABLE_TYPE = 'BASE TABLE')
ORDER BY TABLE_NAME
OPEN @curTabellen
FETCH NEXT FROM @curTabellen INTO @tabelle
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @tabelle
FETCH NEXT FROM @curTabellen INTO @tabelle
END
Sich alle Funktionen ausgeben lassen:
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
where routine_type='FUNCTION'
order by specific_name
Sich alle Prozeduren ausgeben lassen:
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
where routine_type='PROCEDURE'
order by specific_name
Tiefergehende Beispiele findet man z.B. hier:
http://www.simple-talk.com/sql/t-sql-programming/exploring-your-database-schema-with-sql/
http://www.simple-talk.com/sql/t-sql-programming/using-information-schema-views/