MS SQL

Tabellen einer Datenbank auflisten

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

Spaltennamen mit den dazugehörigen Datentypen einer Tabelle auflisten

SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tabellenname'

Datentypen der Spalten einer angegebenen Tabelle auflisten

SELECT c.name AS column_name

    ,c.column_id

    ,SCHEMA_NAME(t.schema_id) AS type_schema

    ,t.name AS type_name

    ,t.is_user_defined

    ,t.is_assembly_type

    ,c.max_length

    ,c.precision

    ,c.scale

FROM sys.columns AS c 

JOIN sys.types AS t ON c.user_type_id=t.user_type_id

WHERE c.object_id = OBJECT_ID('Tabellenname')

ORDER BY c.column_id

Gespeicherten Prozeduren in einer Datenbank auflisten

SELECT name AS procedure_name 

    ,SCHEMA_NAME(schema_id) AS schema_name

    ,type_desc

    ,create_date

    ,modify_date

FROM sys.procedures

Benutzerdefinierten Funktionen in einer Datenbank auflisten

SELECT name AS function_name 

  ,SCHEMA_NAME(schema_id) AS schema_name

  ,type_desc

  ,create_date

  ,modify_date

FROM sys.objects

WHERE type_desc LIKE '%FUNCTION%'