Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Information_schema tables

The Information_schema. tables view contains one row  for each table in the current database to which the user has access. 13> 14> select top 10 * from Information_schema.tables; 15> GO TABLE_CATALOG                                                                                                                    TABLE_SCHEMA                                                           TABLE_NAME                                                                                                                       VIEW_DEFINITI ON                                                                                                                                                                                             CHECK_OPTION  IS_UPDATABLE -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------- --------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------  ------------ (0 rows affected) TABLE_CATALOG                                                                                                                    TABLE_SCHEMA                                                           TABLE_NAME                                                                                                                       TABLE_TYPE -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------- --------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------- master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  BASE TABLE master                                                                                                                           dbo                                                           spt_fallback_dev                                                                                                                 BASE TABLE master                                                                                                                           dbo                                                           spt_fallback_usg                                                                                                                 BASE TABLE master                                                                                                                           dbo                                                           airplane                                                                                                                         BASE TABLE master                                                                                                                           dbo                                                           spt_monitor                                                                                                                      BASE TABLE master                                                                                                                           dbo                                                           spt_values                                                                                                                       BASE TABLE master                                                                                                                           dbo                                                           MSreplication_options                                                                                                            BASE TABLE (7 rows affected) 1>