public bool CloneTableStructure(string cloningTableName)
           {  
               // function return true if table created
               // in othercase return false;
               bool result = false; //variable for result
               #region initsettings
               // init settings
               OdbcDataAdapter sourceDataAdapter; // data adapter for IB database;
               string selectTableStr = String.Format("select * from {0}", cloningTableName); // select statement
               DataTable sourceDataTable;// source data table for cloning
               sourceDataAdapter = new OdbcDataAdapter(selectTableStr, SourceStorage.IBConnection); // get data adapter for table
               DataSet sourceDataSet = new DataSet(); // create dataset instance
               sourceDataTable = new DataTable(cloningTableName);
               try
               {
                   sourceDataAdapter.FillSchema(sourceDataTable, SchemaType.Source);   // retrive table structure    
               }
               catch
               {
                   
               }
               DataTable targetDataTable = new DataTable(cloningTableName); // create instance of cloning table
               targetDataTable = sourceDataTable.Clone(); // create structure copy of table,  new cloned table is Empty
               #endregion

               #region create table statement
               string creatingSqlStatement =""; // variable for Create table sql statement
               string creatingColumnStr = "";
               DataColumnCollection tableColumns = targetDataTable.Columns; // retrive columns collection
               DataColumn theColumn;// current working column
               
               creatingSqlStatement = String.Format("create table {0} ( ", cloningTableName); // add init statement
               
               string newColumnName;
               string newColumnType;
               string newAllowNull;
               string newColumnSeparator;
               // loop by columns
               for (int columnIdx =  0 ; columnIdx < tableColumns.Count; columnIdx++)
               {
                   creatingColumnStr = "";
                   theColumn = tableColumns[columnIdx]; // get column object
                   newColumnName = theColumn.ColumnName; // get column name
                   // get column name;
                   SqlDbType sqlType = TypeConvertor.ToSqlDbType(theColumn.DataType);
                   // NO any varchars only nvarchar
                   if (sqlType == SqlDbType.VarChar)
                   {
                       sqlType = SqlDbType.NVarChar;
                   }
                   newColumnType = sqlType.ToString();
                   
                   if (sqlType == SqlDbType.NVarChar)  // set size for strings
                   {
                       newColumnType += String.Format("({0})", 255  /*theColumn.MaxLength*/);
                       // because column do not have information about real length!!!
                   };
                   //
                   newAllowNull = "";
                   if (!theColumn.AllowDBNull)  // is can be null
                   {
                       newAllowNull = "not null";
                   }
                              
                   // add coma between columns
                   newColumnSeparator = "";
                   if (columnIdx != (tableColumns.Count- 1 ))
                   {
                       newColumnSeparator = " ,"; 
                   }
                   // complite column string
                   creatingColumnStr = newColumnName + " " + newColumnType + " " + newAllowNull + newColumnSeparator;
                   creatingSqlStatement += creatingColumnStr;

                   //MessageBox.Show(creatingColumnStr);
                   //for debug show compiled string
               };
               // finishing create statement
               creatingSqlStatement += ")"; // 
               //MessageBox.Show(creatingSqlStatement); // for debug show full statemnt
               #endregion

               #region createtable
               SqlCommand createSqlCommand = new SqlCommand();
               createSqlCommand.CommandText = creatingSqlStatement;
               createSqlCommand.Connection = MergingStorage.SqlConnection;
               try
               {
                 createSqlCommand.ExecuteNonQuery();
                 result = true;
               }
               catch(Exception e)
               {
                   MessageBox.Show(e.Message);
                   result = false; // if exception then result false;
               }
               return result;

               #endregion



           }
       }