|
| |
| 26. 14. 1. 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>
|
|
|