[thelist] SQL Server - Sql Question

[Tom McMillen]

 --- Josh Spiegel <josh at eaccessit.com> wrote: >
> What all can you query in SQL with SQL server?  Can
> you query usernames
> and passwords?  Table names? Column Names?
>
> Thanks,
> Josh

One of the original aims of a relational database was
that all the database schema (table, column info
etc...) would be stored within itself.

In MS SQL Server this stuff is held in the sys_
tables, but these may change from version to version.
To get the schema info your safer querying the
INFORMATION_SCHEMA data as this will work with future
releases of SQL Server.

Tom

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com