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).
ThanksThese 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment