To view the properties of the sales table, we just have to type the following into the Query Analyzer:
8> CREATE TABLE stores(
9> stor_id char(4) NOT NULL,
10> stor_name varchar(40) NULL,
11> stor_address varchar(40) NULL,
12> city varchar(20) NULL,
13> state char(2) NULL,
14> zip char(5) NULL
15> )
16> GO
1> EXEC sp_help stores
2> GO
Name Owner
Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
--------------------------------------------------------- ------------------------------- -----------------------
stores dbo
user table 2008-08-17 13:04:38.290
Column_name Type
Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNu
llInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
--------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------
------------------------- --------------------------------------------------------------------------------------------------------------------------------
stor_id char
no 4 no no no
SQL_Latin1_General_CP1_CI_AS
stor_name varchar
no 40 yes no yes
SQL_Latin1_General_CP1_CI_AS
stor_address varchar
no 40 yes no yes
SQL_Latin1_General_CP1_CI_AS
city varchar
no 20 yes no yes
SQL_Latin1_General_CP1_CI_AS
state char
no 2 yes no yes
SQL_Latin1_General_CP1_CI_AS
zip char
no 5 yes no yes
SQL_Latin1_General_CP1_CI_AS
Identity Seed Increment
Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ------------------------------
---------- -------------------
No identity column defined. NULL
NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
The object 'stores' does not have any indexes, or you do not have permissions.
No constraints are defined on object 'stores', or you do not have permissions.
No foreign keys reference table 'stores', or you do not have permissions on referencing tables.
No views with schema binding reference table 'stores'.
1>
2>
3> drop table stores;
4> GO