Answer / guest

You can get a list of tables in a database by calling the
INFORMATION_SCHEMA.Tables view like this:

SELECT * FROM information_schema.tables

Answer / shraddha

sp_tables

Answer / kumar.t

Simple query

To Display only user created table.

Select * from sysobjects where xtype='u'

To Display all table.

Select * from sysobjects

Answer / sanjeev kumar

First Method:

select table_name from information_schema.tables


Second Method:

Select Name from sysobjects where xtype='u'

Note: here 'u' means user created

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

---

Describe and explain about SQL native client?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

List the different types of joins?

0 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---

What are sql server functions?

0 Answers  

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---