Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    47

    Unanswered: Information_schema ?

    Hello,

    When the procedure : sp_tables is executed (master db), the table owners are either dbo or INFORMATION_SCHEMA,
    any detail about this last ? (to be precise, table_type is view and not table).

    Thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Talking

    These are system views set up in the master database.

    They can be used as templates for other databases to get meta data info. Like table, constraint and view info.

    All you do is copy them accross into query anyalyzer and create them on your user database.

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •