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

How raid can influence database performance?

0 Answers  

---

How to rebuild all indexes on a single table?

0 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

How can we delete a table in sql server?

0 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

Explain database normalization?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is difference between after and before?

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

How do I view a procedure in sql server?

0 Answers  

---