function ShowMetadataQuery(obj, md){
    var query = md;
    if(md == 'ShowTables')
    {
      query = 
        "select *\n"
      + "  from <database-name>.information_schema.tables\n";
    }
    if(md == 'ShowViews')
    {
      query = 
        "select *\n"
      + "  from <database-name>.information_schema.tables\n"
      + " where table_type='VIEW' \n";
    }
    if(md == 'ShowColumns')
    {
      query = 
        "select *\n"
      + "  from <database-name>.information_schema.columns\n";
    }
    if(md == 'ShowIndexes')
    {
      query = 
    	   "use [database-name] \n"
    	  +"select t.name as table_name \n"
    	  +",      ind.name as index_name \n"
    	  +",      col.name as column_name \n"
    	  +",      ic.index_column_id as column_rank \n"
    	  +"  from sys.indexes ind \n"
    	  +"  ,    sys.index_columns ic \n"   
    	  +"  ,    sys.columns col \n"
    	  +"  ,    sys.tables t \n"
    	  +" where ind.object_id = ic.object_id \n"
    	  +"   and ind.index_id = ic.index_id \n"
    	  +"   and ind.is_primary_key = 0 \n"  
    	  +"   and ind.is_unique = 0 \n"
    	  +"   and ind.is_unique_constraint = 0 \n" 
    	  +"   and t.is_ms_shipped = 0 \n" 
    	  +"   and ic.object_id = col.object_id \n"
    	  +"   and ic.column_id = col.column_id \n"
    	  +"   and ind.object_id = t.object_id \n"
    	  +"order by t.name, ind.name, ic.index_column_id ";
    }
    if(md == 'CreateView')
    {
      query = 
        "create view <myview> as select * from <somedatabase>..<sometable>\n";
    }
    if(md == 'DropTable')
    {
      query = 
        "drop table <mytable>\n";
    }
    if(md == 'CreateIndex')
    {
      query = 
        "create index <index-name> on <mytable>(<column1>,<column2>,...)\n";
    }
    if(md == 'MyDBSize')
    {
      query = 
        "exec sp_spaceused\n";
    }
    if(md == 'MyDBTableSize')
    {
      query = 
        "exec sp_spaceused '<table-name>'\n";
    }
    obj.SQL.value=query;
    return true; 
}

