[thelist] SQL Server - Sql Question
Tom McMillen
tgmcmillen at yahoo.co.uk
Fri Jul 12 17:01:01 CDT 2002
--- 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
More information about the thelist
mailing list