Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Select top 10 from Information_schema columns

4>  select top 10 *  from Information_schema.columns 5> GO TABLE_CATALOG                                                                                                                    TABLE_SCHEMA                                                           TABLE_NAME                                                                                                                       COLUMN_NAME                                                                                                                     ORDINAL_POSITION COLUMN_DEFAULT                                                                                                                                       IS_NULLABLE DATA_TYPE                                                                            CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE DATETIME_PRECISION CH ARACTER_SET_CATALOG                                                                                                            CHARACTER_SET_SCHEMA                                                         CHARACTER_SET_NAME                                                                                                               COLLATION_CATAL OG                                                                                                                COLLATION_SCHEMA                                            COLLATION_NAME                                                                                                                   DOMAIN_CATALOG                                                                                                      DOMAIN_SCHEMA                               DOMAIN_NAME -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------- --------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------------------------------------------------------------------------------------------------------------- ---------------- ------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------------------------------------------ -------------------------------------------------------------------------- ------------------------ ---------------------- ----------------- ----------------------- ------------- ------------------ -- ------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------- ------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------- ----------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- ------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ---------------------------- ---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------- ----------------------------- -------------------------------------------------------------------------------------------------------------------------------- master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  xserver_name                                                                                                                                    1 NULL                                                                                                                                       NO          varchar                                                                                                  30                     30              NULL                    NULL          NULL               NULL NU LL                                                                                                                             NULL                                                         iso_1                                                                                                                            NULL                                                                                                                   NULL                                            SQL_Latin1_General_CP1_CI_AS                                                                                                     NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  xdttm_ins                                                                                                                                    2 NULL                                                                                                                                       NO          datetime                                                                                                NULL                   NULL              NULL                    NULL          NULL                  3 NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  xdttm_last_in s_upd                                                                                                                              3 NULL                                                                                                                                       NO          datetime                                                                                                NULL                   NULL              NULL                    NULL          NULL                  3 NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  xfallback_dbi d                                                                                                                                  4 NULL                                                                                                                                       YES         smallint                                                                                                NULL                   NULL                 5                      10             0               NULL NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  name                                                                                                                                    5 NULL                                                                                                                                       NO          varchar                                                                                                  30                     30              NULL                    NULL          NULL               NULL NU LL                                                                                                                             NULL                                                         iso_1                                                                                                                            NULL                                                                                                                   NULL                                            SQL_Latin1_General_CP1_CI_AS                                                                                                     NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  dbid                                                                                                                                    6 NULL                                                                                                                                       NO          smallint                                                                                                NULL                   NULL                 5                      10             0               NULL NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  status                                                                                                                                    7 NULL                                                                                                                                       NO          smallint                                                                                                NULL                   NULL                 5                      10             0               NULL NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_db                                                                                                                  version                                                                                                                                    8 NULL                                                                                                                                       NO          smallint                                                                                                NULL                   NULL                 5                      10             0               NULL NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_dev                                                                                                                 xserver_name                                                                                                                                    1 NULL                                                                                                                                       NO          varchar                                                                                                  30                     30              NULL                    NULL          NULL               NULL NU LL                                                                                                                             NULL                                                         iso_1                                                                                                                            NULL                                                                                                                   NULL                                            SQL_Latin1_General_CP1_CI_AS                                                                                                     NULL                                                                                                      NULL                               NULL master                                                                                                                           dbo                                                           spt_fallback_dev                                                                                                                 xdttm_ins                                                                                                                                    2 NULL                                                                                                                                       NO          datetime                                                                                                NULL                   NULL              NULL                    NULL          NULL                  3 NU LL                                                                                                                             NULL                                                         NULL                                                                                                                             NULL                                                                                                                   NULL                                            NULL                                                                                                                             NULL                                                                                                      NULL                               NULL (10 rows affected) 1> 2>