Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

tables names

Hi
how to list all the table names in a db from (any sys)?

thanx
0
LuckyLucks
Asked:
LuckyLucks
  • 2
1 Solution
 
curtis591Commented:
select * from sysobjects where type = 'u' will give you the tables.
0
 
curtis591Commented:
If you go to the following link
http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp you can download a chm file
that describes all the sql system tables and what is inside each of them.
0
 
obahatCommented:
It is not a good practice to query sysobjects.
These are system tables.

Use:

SELECT * FROM INFORMATION_SCHEMA.TABLES

to get the table listing.

Look at other INFORMATION_SCHEMA views for your convenience.

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now