need description of these tables

Question

need description of these tables

Manny Cruz

SSC Veteran

Points: 252
More actions
March 3, 2010 at 11:59 am

#211803

Hello
I have just a rudimentary knowledge of SQL
We have an app that is SQL 2000 based
Sometimes I read a tech doc and ofcourse - i run into many questions
for now, i just would like someone to explain what the
SYSOBJECTS and SYSCOLUMNS tables represent
please break it down in simple terms if that is possible
thx

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

Try the following:

Open Query Editor (or whatever the name was back in SQL 2000... I simply forgot). Highlight the word "sysobjects" and press {F1}. IIRC it will open the SQL Server help system (aka BooksOnline) with the related section.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Garadin One Orange Chip Points: 29613 More actions · Answer 2

I believe normal hotkey usage is that F1 just opens BOL, SHIFT+F1 opens it and goes to the section you have a word highlighted from.

[Edit] OOps, didn't realize how old this post was.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Manny Cruz (3/3/2010)
Hello
I have just a rudimentary knowledge of SQL
We have an app that is SQL 2000 based
Sometimes I read a tech doc and ofcourse - i run into many questions
for now, i just would like someone to explain what the
SYSOBJECTS and SYSCOLUMNS tables represent
please break it down in simple terms if that is possible
thx

Boy does this sound like a homework question.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

ya but from 18 days ago... so maybe not a bad idea to answer it now :-D.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Late for the homework or not, here are some links to the topics

http://msdn.microsoft.com/en-us/library/aa260447(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa260398(SQL.80).aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events