Post reply

Write a query to list the user tables within a database

  • December 18, 2008 at 3:19 am

    #125971

    Hi,

    What is User Tables?

    Are these different from the tables that we create within a database?

    Write a query to list the user tables within a database.

    Thanks

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

  • December 18, 2008 at 6:07 am

    #914455

    SELECT name FROM sysobjects WHERE xtype = 'U'

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • December 18, 2008 at 6:10 am

    #914457

    OK.

    User tables are those tables you create on the database.

    Now if you type the following query then you will get a list of all user tables on the database:

    Select *

    From Sys.Tables

    ---- and the same applies for user views and stored procs. see this link for more info:

    http://www.alberton.info/sql_server_meta_info.html

  • December 18, 2008 at 6:49 am

    #914491

    User tables, as has already been stated, are your tables. This is opposed to system tables (and views) which are the management tables (and views) for SQL Server itself.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply