示例#1
0
        protected virtual string GetStatementSql(DropStatement statement)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("DROP ");
            switch (statement.DropType)
            {
            case DropStatementType.Database:
                sb.Append("DATABASE ");
                break;

            case DropStatementType.Table:
                sb.Append("TABLE ");
                break;

            case DropStatementType.Index:
                sb.Append("INDEX ");
                break;

            case DropStatementType.Procedure:
                sb.Append("PROCEDURE ");
                break;

            case DropStatementType.View:
                sb.Append("VIEW ");
                break;
            }

            sb.Append(GetSql(statement.Identifier));
            sb.Append(';');

            return(sb.ToString());
        }
示例#2
0
		protected virtual string GetStatementSql (DropStatement statement)
		{
			StringBuilder sb = new StringBuilder ();
			
			sb.Append ("DROP ");
			switch (statement.DropType) {
				case DropStatementType.Database:
					sb.Append ("DATABASE ");
					break;
				case DropStatementType.Table:
					sb.Append ("TABLE ");
					break;
				case DropStatementType.Index:
					sb.Append ("INDEX ");
					break;
				case DropStatementType.Procedure:
					sb.Append ("PROCEDURE ");
					break;
				case DropStatementType.View:
					sb.Append ("VIEW ");
					break;
			}
			
			sb.Append (GetSql (statement.Identifier));
			sb.Append (';');
			
			return sb.ToString ();
		}