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

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

Explain how many normalization forms?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

---

How to select some specific rows from a table in ms sql server?

0 Answers  

---

What are triggers in ms sql server?

0 Answers  

---

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

How do triggers work?

0 Answers  

---

How to create an identity column?

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---