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

Difference between server.transfer and server.execute method?

2 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

what are the problems in logshipping?

3 Answers  

---

Explain partitioned view?

0 Answers  

---

How secure is sql server database?

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

how can a database be repaired? : Sql server administration

0 Answers  

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

What is postgresql server?

0 Answers  

---

What do you understand by a view?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---