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 SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

What are the system database in sql server 2008?

0 Answers  

---

What is bcnf normalization form?

0 Answers  

---

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---

What is openxml in sql server?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

How to verify the port number of the sql server?

0 Answers  

---

Can we do dml on views?

0 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

What is equi join with example?

0 Answers  

---