--------------- --------------- ---------------------- courses dbo user table coursesoffered dbo user table enroll_period dbo user table enrollment dbo user table faculty dbo user table grades dbo user table prereq dbo user table recordnotes dbo user table security dbo user table students dbo user table --------------- -------- courseno varchar 3 NULL NULL 0 NULL NULL 0 name varchar 30 NULL NULL 1 NULL NULL 0 description text 16 NULL NULL 1 NULL NULL 0 index_name index_description index_keys index_max_rows_per_page index_fillfactor index_reservepagegap -------------------- -------------------------------------------------------- ------------------------------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------- ----------------------- ---------------- -------------------- pk_c clustered, unique located on default courseno 0 0 0 1> sp_help coursesoffered 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- coursesoffered dbo user table --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- cid numeric 5 9 0 0 NULL NULL 1 courseno varchar 3 NULL NULL 0 NULL NULL 0 sectionno varchar 3 NULL NULL 1 NULL NULL 0 year varchar 4 NULL NULL 1 NULL NULL 0 quarter varchar 10 NULL NULL 1 NULL NULL 0 url varchar 100 NULL NULL 1 NULL NULL 0 daytime varchar 50 NULL NULL 1 NULL NULL 0 room varchar 3 NULL NULL 1 NULL NULL 0 building varchar 20 NULL NULL 1 NULL NULL 0 fssn varchar 9 NULL NULL 1 NULL NULL 0 index_name index_description index_keys 1> sp_help grades 2> gp o Name Owner Type ------------------------------ ------------------------------ ---------------------- grades dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Dec 4 2000 11:41PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- ssn varchar 9 NULL NULL 0 NULL NULL 0 cid numeric 4 5 0 0 NULL NULL 0 grades char 1 NULL NULL 0 NULL NULL 0 gpa float 8 NULL NULL 0 NULL NULL 0 1> sp_help student 2> go Msg 17461, Level 16, State 1 , Procedure 'sp_help', Line 179 Object does not exist in this database. (return status = 1) 1> sp_help students 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- students dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Nov 25 2000 2:04PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- ssn varchar 9 NULL NULL 0 NULL NULL 0 fname varchar 20 NULL NULL 1 NULL NULL 0 lname varchar 20 NULL NULL 1 NULL NULL 0 midinit varchar 1 NULL NULL 1 NULL NULL 0 email varchar 50 NULL NULL 1 NULL NULL 0 address1 varchar 50 NULL NULL 1 NULL NULL 0 phone varchar 20 NULL NULL 1 NULL NULL 0 gender varchar 1 NULL NULL 1 NULL NULL 0 admit_qtr varchar 15 NULL NULL 1 NULL NULL 0 admit_year varchar 4 NULL NULL 1 NULL NULL 0 address2 varchar 50 NULL NULL 1 NULL NULL 0 city varchar 50 NULL NULL 1 NULL NULL 0 state varchar 2 NULL NULL 1 NULL NULL 0 zip varchar 10 NULL NULL 1 NULL NULL 0 (1 row affected, return status = 0) 1> sp_help grades 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- grades dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Dec 4 2000 11:41PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- ssn varchar 9 NULL NULL 0 NULL NULL 0 cid numeric 4 5 0 0 NULL NULL 0 grades char 1 NULL NULL 0 NULL NULL 0 gpa float 8 NULL NULL 0 NULL NULL 0 1> sp_help faculty 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- faculty dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Nov 8 2000 10:07PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- fssn varchar 9 NULL NULL 0 NULL NULL 0 fname varchar 20 NULL NULL 1 NULL NULL 0 lname varchar 20 NULL NULL 1 NULL NULL 0 midinit varchar 1 NULL NULL 1 NULL NULL 0 url varchar 50 NULL NULL 1 NULL NULL 0 address1 varchar 50 NULL NULL 1 NULL NULL 0 address2 varchar 50 NULL NULL 1 NULL NULL 0 city varchar 50 NULL NULL 1 NULL NULL 0 state varchar 2 NULL NULL 1 NULL NULL 0 zip varchar 10 NULL NULL 1 NULL NULL 0 phone varchar 20 NULL NULL 1 NULL NULL 0 gender varchar 1 NULL NULL 1 NULL NULL 0 specialty varchar 20 NULL NULL 1 NULL NULL 0 dept varchar 30 NULL NULL 1 NULL NULL 0 email varchar 50 NULL NULL 1 NULL NULL 0 1> sp_help enroll_period 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- enroll_period dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Dec 2 2000 3:56PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- quarter varchar 10 NULL NULL 0 NULL NULL 0 year varchar 4 NULL NULL 0 NULL NULL 0 description varchar 50 NULL NULL 1 NULL NULL 0 status varchar 10 NULL NULL 1 NULL NULL 0 1> so p_help security 2> go Name Owner Type ------------------------------ ------------------------------ ---------------------- security dbo user table (1 row affected) Data_located_on_segment When_created ------------------------------ ------------------- default Nov 25 2000 2:46PM Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity --------------- --------------- ------ ---- ----- ----- --------------- --------------- -------- username varchar 20 NULL NULL 0 NULL NULL 0 password varchar 20 NULL NULL 0 NULL NULL 0 status varchar 20 NULL NULL 1 NULL NULL 0 ssn varchar 9 NULL NULL 1 NULL NULL 0