Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 2 noob questions, documentation site and ...

Author  Topic 

Moozzie
Starting Member

17 Posts

Posted - 2007-10-23 : 05:42:44
Hi all,

I'm new to mssql but not new to sql beceause i did (and still do mysql)
But i need to learn mssql for my job. I have some (noob) questions which will help me learning mssql faster. So here they are:

1. What is a good mssql site where all there functions are listed?
(like www.mysql.org for mysql)

2. What is the function to get all the table names from my database?

Thanks!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-23 : 05:46:54
1
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


2 Select table_name from information_schema.tables where table_type='BASE TABLE'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Moozzie
Starting Member

17 Posts

Posted - 2007-10-23 : 06:22:12
Thank you very much :-)
Go to Top of Page
   

- Advertisement -