Alle angelegten Tabellen anzeigen

ID51
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupDatenbank
PlItemTitleAlle angelegten Tabellen anzeigen
CodeSELECT
T.TABLE_CATALOG
,T.TABLE_SCHEMA
,T.TABLE_NAME
,T.TABLE_TYPE
FROM
INFORMATION_SCHEMA.TABLES T
Result Example
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
dbo v_Countries ID VIEW
dbo Countries ID BASE TABLE