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

What do you understand by sql server agent?

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

What is a trace frag?

0 Answers  

---

How do you manipulate data?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

What extended events?

0 Answers  

---

What language is sql server written in?

0 Answers  

---

What is awe?

0 Answers  

---