--SELECT name, state, state_desc DatabaseStatus_sysDatabase
/*
--This Query Generates a list of Databases
SELECT name
FROM sys.databases
WHERE name <> 'master' 
And name <> 'tempdb' 
And name <> 'model'
And name <> 'msdb'
And name <> 'ReportServer'
And name <> 'ReportServerTempDB'
And name <> ''
And state = 0
GO
*/
/*
--This Query Generates a List of Tables
Select TABLE_NAME
FROM WordTricks.INFORMATION_SCHEMA.TABLES
GO
*/
--SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, 
--COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH 
--/*
Select '  <gItem>[CR]  <iCaption>' + COLUMN_NAME + '</iCaption>[CR]  <iText></iText>[CR]  <iField>' + COLUMN_NAME + '</iField>[CR]  <iType>0</iType>[CR]  <iInstruct></iInstruct>[CR]  </gItem>[CR]'

FROM WordTricks_Dev.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'DocClients';
GO
--*/
/*
--This Query returns Table Specific Information
SELECT
TABLE_CATALOG,
TABLE_SCHEMA,
TABLE_NAME
FROM WordTricks.INFORMATION_SCHEMA.TABLES
Order By TABLE_NAME;
*/

/*
--This Query returns Column Specific Information
SELECT 
TABLE_NAME,
COLUMN_NAME,
COLUMN_DEFAULT,
IS_NULLABLE, 
DATA_TYPE, 
CHARACTER_MAXIMUM_LENGTH 
FROM WordTricks.INFORMATION_SCHEMA.COLUMNS
Order By TABLE_NAME, COLUMN_NAME;
*/