Forgot your password?
Views
Wiki Main Page
>>
Programming
>>
MSSQL
Document Actions
last edited 1 year ago by cinnion
Get the list of databases with:
SELECT * FROM SYS.DATABASES
Get the list of tables from the current database:
SELECT * FROM sys.Tables
Get the schema of a table (``customer'' in this example)
sp_help customer
Help Save The Internet
