Post reply

Schema Information

  • August 16, 2007 at 7:50 am

    #76758

    Hi Team,

    Please excuse my question, I'm a newby to SQL and need to find out some information.

    I've been passed a script to run, however before I run it I need to find the schema information for the database. My Database is named 'Manufacturing' so is this the schema name?

     

    Thanks.

  • August 16, 2007 at 10:12 am

    #727426

    Actually, in SQL 2000, schema is equivalent to the owner of an object.  So, if all the objects are with 'dbo' e.g.  'dbo.tablename' or 'dbo.sprocname', 'dbo' is the schema name.

    Greg

    Greg

  • August 17, 2007 at 3:07 am

    #727573

    Greg,

    Many thanks!.

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

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